Missing Index Dynamic Management Objects
In addition to the Database Engine Tuning Advisor, SQL Server 2014 provides 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 dynamic management objects:
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 ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
