Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  SQL2005 performance Dashboard

Author  Topic  kriki Starting Member 14 Posts Posted - 2007-07-09 : 14:57:34 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;