Waits by Type
The waits by type page shows you the most commonly occurring waits on your SQL Server.
![](http://databasehealth.com/wp-content/uploads/2022/02/waitsforinstance1-1024x540.png)
Grid Columns
- Row: Just the row number in the grid.
- Type: The name of this wait type.
- Wait Seconds: The total amount of time this type of wait has been waiting since SQL Server was last restarted, or since the wait stats were last cleared.
- Percent: The percentage that this wait takes up of all the waits on the system.
![](http://databasehealth.com/wp-content/uploads/2022/02/waitsforinstance2-1024x540.png)
You can clear the wait stats with the following command
DBCC SQLPERF (‘sys.dm_os_wait_stats’, CLEAR);
After clearing the wait stats the counters start out fresh like when you restart your SQL Server.
![](http://databasehealth.com/wp-content/uploads/2022/02/waitsforinstance4-1024x473.png)
Enroll Today!
![SteveStedman5](http://databasehealth.com/wp-content/uploads/2021/10/DHMimage1-1.png)
![SteveStedman5](https://stevestedman.com/wp-content/uploads/2021/03/button-16.png)
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!
Leave a Reply