Databases
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.
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)