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.
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment