Wait Statistics

The 9 checks in the “Wait Statistics” category of a SQL Server audit: what each one verifies, its severity and the versions covered.

Checks in this category

WAIT002
Signal Wait Ratio (CPU Pressure)
High
Calculates the signal wait / total wait ratio to detect CPU pressure
Versions : 2012-2025
WAIT003
Lock Contention (LCK_M*)
High
Detects lock contention (LCK_M*) indicating concurrency issues
Versions : 2012-2025
WAIT004
PAGEIOLATCH (Disk I/O Bottleneck)
High
Detects high PAGEIOLATCH waits indicating a disk I/O bottleneck
Versions : 2012-2025
WAIT005
WRITELOG (Log Write Latency)
High
Detects high WRITELOG waits indicating transaction log write latency
Versions : 2012-2025
LATCH001
Top non-buffer latch waits
Medium
Identifies the dominant non-buffer latch class (cumulative), an indicator of internal contention.
Versions : 2012-2025
WAIT006
ASYNC_NETWORK_IO (Slow Client)
Medium
Detects high ASYNC_NETWORK_IO waits indicating a slow application client
Versions : 2012-2025
WAIT007
CXPACKET (Parallelism)
Medium
Detects high CXPACKET waits indicating parallelism issues
Versions : 2012-2025
WAIT008
SOS_SCHEDULER_YIELD (CPU Yield)
Medium
Detects high SOS_SCHEDULER_YIELD waits indicating CPU saturation
Versions : 2012-2025
WAIT001
Top 5 Wait Types
Info
Identifies the top 5 most frequent wait types on the instance
Versions : 2012-2025