MSSQLWIKI

Karthick P.K on SQL Server

«
»

Script to clear stats

Posted by Karthick P.K on January 20, 2010

How to reset SQL Server stats with out restarting.

DBCC SQLPERF ('spinlockstats', CLEAR);

 

GO

 

DBCC SQLPERF ('netstats', CLEAR);

 

GO

 

DBCC SQLPERF ('rastats', CLEAR);

 

GO

 

DBCC SQLPERF ('iostats', CLEAR);

 

GO

 

DBCC SQLPERF ('threads', CLEAR);

 

GO

 

DBCC SQLPERF ('logspace', CLEAR);

 

GO

 

DBCC SQLPERF ('umsstats', CLEAR);

 

GO

 

DBCC SQLPERF ('waitstats', CLEAR);

 

GO

This entry was posted on January 20, 2010 at 5:59 PM and is filed under Performance, SQL General, SQL Query. Tagged: . You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “Script to clear stats”

  1. pay day loan said

    April 17, 2013 at 5:58 AM

    I simply could not depart your website before suggesting that I really loved the standard info a person provide on your visitors?
    Is going to be back frequently to check out new posts

    Reply

  2. Top SQL Server blogs from MSSQLWIKI « MSSQLWIKI said

    January 11, 2014 at 12:57 PM

    […] Script to clear stats […]

    Reply

Leave a comment

«
»