Tuesday, May 24, 2011

Clear DMV stats

Just found that we can clear DMV stats using the below query:

DBCC SQLPERF('sys.dm_os_latch_stats', CLEAR)
here you can mention any other DMV where you want to clear before starting your analysis.