SQL Server Performance

Reset statistics (Performance dashboard)

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by wicket, May 13, 2007.

  1. wicket New Member

    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
  2. satya Moderator

    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.
  3. wicket New Member

    Oh, thank you!
    I think 'dbcc freeproccache' will do fine for me. This is not a production db...

    Regards Andreas
  4. satya Moderator

    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.

Share This Page