Five DMVs worth memorizing show SQL Server sessions, active requests, waits, index use, and file I/O during an incident.
Comparing Two Wait Stats Snapshots to See What Changed
Compare wait stats snapshots over a chosen window, subtract cumulative counters, remove background waits, and calculate rates and average waits.
Seeing What Is Running Right Now
See what is running right now in SQL Server with request DMVs, statement text, plans, waits, and blocking details in one reusable query.
Stress Testing a Query Before Release
Stress testing a query before release reveals concurrency and parameter risks; learn to design realistic SQL Server tests and compare useful metrics.
Memory Grants: Why a Query Waits for Memory
Memory grants can leave SQL Server queries waiting on RESOURCE_SEMAPHORE; inspect estimates, grants, and spills before adding memory.
A Simple Dashboard From DMVs
A dashboard from DMVs can show live requests, database state, waits, and backups when its queries refresh without adding load.