September 2010
Intermediate to advanced
1704 pages
111h 8m
English
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 ...