July 14, 2010 at 10:53 am
I'm used to using Performance Dashboard for SQL Server 2005 and 2008. It's not compatible with SQL Server 2000.
Can anyone direct me to a set of queries that would allow me to identify missing indexes in a SQL Server 2000 database?
Thanks,
LC
July 14, 2010 at 1:12 pm
After doing some research, I'll answer my own question.
“It has been always challenging for database administrators to identity indexes that are missing on a table. In SQL Server 2005, Microsoft introduced Dynamic Management Views (DMVs). The role of DMVs is to return SQL Server state information; which can be used by database administrators and database developers to monitor the health of an SQL Server Instance and identify potential performance issues. DMVs reflect all the activities on the instance of SQL Server since the last restart. Unfortunately in SQL Server editions prior to SQL Server 2005 there is no easy way to identify missing indexes on a table. In SQL Server 2000 the only way to identify if an index needs to be created is to capture a workload in SQL Profiler and then run it against the Index Tuning Wizard.”
LC
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy