Skip to content

Day 7 – Waits by Type for Instance

for instances

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

Waits for instance

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.

You can get to this report by going to the Server Overview page and clicking the gray button in the instance report section for “Waits”.


See Also:


 

More from Stedman Solutions:

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 *