SQL2005 performance Dashboard | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL2005 performance Dashboard

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;
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.
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 />
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;
See thishttp://www.sql-server-performance.com/bm_performance_dashboard_2005.asp is any help to clear your problem. 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.
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.

I checked out both http://www.sql-server-performance.com/bm_performance_dashboard_2005.asp and the dbcc sqlperf topic in BOL but no help.
It seems the only thing possible is the restart the service. IF Debugging = removing bugs from program THEN programming := putting bugs in program;
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.
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!"
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>
]]>