Reset statistics (Performance dashboard) | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Reset statistics (Performance dashboard)

I have installed the reports for the performance dashboard and really like it!
http://www.microsoft.com/downloads/…0d-7e0c-4730-8204-e419218c1efc&displaylang=en) However, I’d like to be able to clear the stats in order to run specific procedures etc and see the most inefficient parts in the specific procedure. The documentation says like this about it: The lifetime of the DMV data depends on the lifetime of the plan in cache. You can determine how long the plan has been cached, and thus the time frame over which these resources have been consumed, by looking at the Plan Cached column What Plan Cashed column? Can someone explain to me how to clear the stats? Regards Andreas
http://www.microsoft.com/technet/prodtechnol/sql/2005/recomp.mspx fyi and also look into BOL for sys.dm_exec_query_planhttp://msdn2.microsoft.com/en-us/library/ms187404.aspx and you might know that using "dbcc freeproccache” or “dbcc freesystemcache” will clear the plan cache for the instance of SQL Server. But this is not suggested to run on a production instance until you have tested the implications of them.
http://sqlserver-qa.net/blogs/perft…op-stored-procedures-that-are-recompiled.aspx fyi too. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Oh, thank you!
I think ‘dbcc freeproccache’ will do fine for me. This is not a production db… Regards Andreas
Then go for it, in order to get the stats it is better to run the referred DMV above for more information. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>