This script returns the top wait types since the last SQL Server restart or wait statistics clear, excluding common idle and background waits. It provides a quick high-level view of where the instance is spending time.
This is often the first script run during performance investigations to identify whether the primary pressure is related to I/O, CPU, locking, or memory.
The Script
Example Output
The result set shows the top wait types ordered by total wait time, including how long SQL Server has spent waiting and what percentage of total waits each type represents.
This provides a quick view of the dominant resource pressure on the instance.
Notes
- Results are cumulative since the last restart or manual wait stats clear
- Idle and background waits are excluded for clarity
- High signal wait time can indicate CPU pressure
- Useful as a first step before deeper query-level analysis
Leave a Reply