How To Identify Missing Indexes in a SQL Server 2000 Database?

  • 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

  • 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.

    http://www.sql-server-performance.com/articles/per/Identify_Missing_Indexes_Using_SQL_Server_DMVs_p1.aspx

    LC

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply