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.
Share to Twitter
Share to Facebook
Share to Pinterest