Microsoft SQL Server 2005 Performance Tuning Best Practices
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