SQL Server – Reset or Clear the Wait Stats counter

SQL, SQL-Advanced, SQL-Performance, SQL-Tips and Tricks, Varinder Sandhu

We can find the wait stats as posted here

We can Reset or clear the wait stats using

-- Reset or clear the wait stats counter

DBCC SQLPERF (waitstats, clear)
Reset or Clear the Wait Stats counter

Reset or Clear the Wait Stats counter

Hope this will help you.

Related Posts

,