SQL Server Performance

SQL2005 performance Dashboard

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by kriki, Jul 11, 2007.

  1. kriki New Member

    I am using this tool to tune the performance. And it is really helpfull.
    Especially the missing indexes part and the statements that request a lot of resources.
    So sometimes I fix something and I notice that a statement is not run anymore. The last run-column doesn't change anymore. But I would like to reset the counters so those heavy statements disappear.
    In the SQL Server books Online I found some statements, tried them but they don't seem to reset the counters for the SQL2005 Performance Dashboard.
    What statement(s) must I use to reset the counters?

    IF Debugging = removing bugs from program THEN programming := putting bugs in program;
  2. satya Moderator

    What statements you found from BOL?

    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. alzdba Member

    SQL2005PD uses DMV's for the reports. <br />- Some counters are only "reset" by stop/start of sqlserver because the DMV's start living another life again <img src='/community/emoticons/emotion-5.gif' alt=';)' /><br />
  4. kriki New Member

    I found:

    DBCC FREESYSTEMCACHE
    DBCC FREEPROCCACHE

    But they didn't do what I wanted.
    But I already was afraid for the answer of alzdba.
    But if someone knows some trick to do it, let me know.




    quote:Originally posted by satya

    What statements you found from BOL?

    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.

    IF Debugging = removing bugs from program THEN programming := putting bugs in program;
  5. satya Moderator

  6. MohammedU New Member

    Check dbcc sqlperf topic in BOL...


    MohammedU.
    Microsoft SQL Server MVP
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  7. kriki New Member

  8. satya Moderator

    Good insight, why don't you putup the same onhttp://www.connect.microsoft.com site in this case.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    @http://www.askasqlguru.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.
  9. MichaelB Member

    I have to admit.. I have been looking for something like sql dashboard. wow<img src='/community/emoticons/emotion-1.gif' alt=':)' /><br />I dont know how I missed this gem<img src='/community/emoticons/emotion-1.gif' alt=':)' /> I was looking at some MS reports for RS server stats, but this is wonderful!!! Thanks for bringing up the topic<img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br /><br /><br />Michael <br />MCDBA<br /><br />"The statistics on sanity are that one out of every four persons is suffering from some sort of mental illness. Think of your three best friends -- if they're okay, then it's you!"
  10. satya Moderator

    http://msmvps.com/blogs/ssqa/archive/2007/06/26/sql-server-2005-performance-dashboard-reports-making-most-out-of-it.aspx [<img src='/community/emoticons/emotion-5.gif' alt=';)' />] making most out of it.<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br />@<a target="_blank" href=http://www.askasqlguru.com/>http://www.askasqlguru.com/</a><br /><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</i></font id="size1"></font id="teal"></center>

Share This Page