Data Monitoring
Many sessions wait although only one transaction is blocking progress. Capture blocker relationships, wait resource and transaction context together.
SQL Server Query Performance2 min read
Read article : SQL Server: Blocking chain identification
Data Monitoring
An idle application session holds locks and prevents progress. Compare session state with open transaction age and the last relevant request.
SQL Server Query Performance2 min read
Read article : SQL Server: Long-running open transactions
Data Monitoring
An old cumulative wait total is interpreted as a current incident. Take two bounded snapshots and note instance restart or wait-stat reset times.
SQL Server Query Performance2 min read
Read article : SQL Server: Wait statistics deltas
Data Monitoring
Queries queue even though CPU is not saturated. Inspect pending grants, requested memory and concurrent expensive statements.
SQL Server Query Performance2 min read
Read article : SQL Server: Memory grant waits
Data Monitoring
A query unexpectedly writes large temporary work to disk. Inspect execution evidence for spills alongside row estimates and granted memory.
SQL Server Query Performance2 min read
Read article : SQL Server: Sort and hash spills
Data Monitoring
The same query is fast for one value and slow for another. Compare representative parameter distributions, plan choices and actual row counts.
SQL Server Query Performance2 min read
Read article : SQL Server: Parameter-sensitive behavior
Data Monitoring
Estimated row counts diverge sharply from observed work. Compare data changes and statistics freshness with the affected predicates.
SQL Server Query Performance2 min read
Read article : SQL Server: Stale statistics symptoms
Data Monitoring
A filtered lookup becomes a scan after an application type change. Compare parameter types, column types and execution-plan conversion warnings.
SQL Server Query Performance2 min read
Read article : SQL Server: Implicit conversion predicates
Data Monitoring
An automated suggestion improves one query but increases write costs. Compare the proposed key and includes with existing indexes and representative write workload.
SQL Server Query Performance2 min read
Read article : SQL Server: Missing index suggestions
Data Monitoring
A query disappears from cache after memory pressure. Compare current cached plans with historical Query Store evidence where available.
SQL Server Query Performance2 min read
Read article : SQL Server: Plan cache versus history
Data Monitoring
A single DMV snapshot catches no evidence of an intermittent slowdown. Capture bounded repeated observations aligned with application incident times.
SQL Server Query Performance2 min read
Read article : SQL Server: Active request snapshots
Data Monitoring
A parallel query uses substantial CPU but completes faster. Compare elapsed time, total worker time and concurrency impact together.
SQL Server Query Performance2 min read
Read article : SQL Server: Parallel query interpretation