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_statsReturns 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_groupsReturns 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 ...

Get Microsoft® SQL Server 2008 R2 Unleashed now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.