Waits by Type

The waits by type page shows you the most commonly occurring waits on your SQL Server.

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.

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.


Enroll Today!
SteveStedman5
SteveStedman5
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

Your email address will not be published. Required fields are marked *

*

To prove you are not a robot: *