Read Azure SQL Database wait stats with sys.dm_db_wait_stats, identify log-rate governance, and compare resource percentages before scaling.
Reading the Top Five Wait Types on Your Server
Top five wait types become useful when you filter background waits, measure changes over time, and connect them to active work.
Index Usage Stats Reset: Reading Them Without Being Fooled
Use index usage stats reset in SQL Server with practical examples, clear checks, and the limits you need before changing your database.
Signal Waits: Telling CPU Pressure From Slow Disks
Measure signal waits over an interval, compare scheduler queues and file latency, and separate CPU scheduling pressure from storage delays.
Running, Runnable, Suspended: The Life of a Query in sys.dm_exec_requests
Read running, runnable, and suspended SQL Server requests, inspect task states, and compare scheduler queues before diagnosing CPU pressure.
Learning SQL Wait Stats: The Complete Series Guide
Learning SQL Wait Stats is the fastest way I know to find out why a SQL Server is slow. This guide lists every post in my wait stats series, told as one story about an all-night diner, and answers the questions readers ask before they start.
SQL SERVER – Learning More About SQL Wait Stats
Are SQL Wait Stats still relevant for performance tuning? Absolutely. Here is what I told a customer in Delhi and where to start learning about them.