Microsoft SQL Server 2005
Performance Tuning
Best Practices

How to reset sys.dm_os_wait_stats DMV statistics?

 

Execute the following script in Query Editor to clear the statistics in the performance tuning DMV:

USE AdventureWorks
GO

SELECT * FROM sys.dm_os_wait_stats
GO

DBCC SQLPERF ('sys.dm_os_wait_stats', CLEAR);
GO

SELECT * FROM sys.dm_os_wait_stats
GO

 

 

The Best SQL Server 2005 Training in the World
 
 
SQLUSA.com Home Page