Microsoft® SQL Server 2008 R2 Unleashed

Missing Index Dynamic Management Objects

In addition to the Database Engine Tuning Advisor, SQL Server 2008 introduces the missing index dynamic management objects to help identify potentially missing indexes in your database. The missing index dynamic management objects are a set of new dynamic management objects introduced in SQL Server 2008:

• sys.dm_db_missing_index_group_stats—Returns summary information about missing index groups, such as the performance improvements that could be gained by implementing a specific group of missing indexes.

• sys.dm_db_missing_index_groups—Returns information about a specific group of missing indexes, such as the group identifier and identifiers of all missing indexes contained in that group.

• sys.dm_db_missing_index_columns ...