December 23, 2008 at 12:06 pm
DBCC DROPCLEANBUFFERS does not reset these dmv's ... is there any way to do so without restarting the service?
Thanks
December 23, 2008 at 1:15 pm
No.
I thinks DMV's get refreshed when either the service or server gets restarted.
December 29, 2008 at 9:33 am
+1
I think DMVs are "cumulative" until you restart SQL Server, or reset it
e.g. for wait DMV
Reset by DBCC SQLPERF ('sys.dm_os_wait_stats', CLEAR);GO
December 29, 2008 at 10:44 am
Don’t know if it helps you but whenever a database is detached or is shut down (for example, because AUTO_CLOSE is set to ON), all rows associated with the database will also be deleted (you can read about at http://msdn.microsoft.com/en-us/library/ms188755.aspx).
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply