Monitoring Enhancements
SQL Server 2014 also introduces a few new dynamic management views (DMVs) and enhancements to existing DMVs. These have mostly been in support of Availability Groups and managing the lock priority of online operations but have also added some additional columns to several other DMVs. The DMV enhancements include:
sys.xml_indexes—Includes 3 new columns: xml_index_type, xml_index_type_description, and path_id.
sys.dm_exec_query_profiles—New DMV to monitor real time query progress while a query is in execution.
sys.column_store_row_groups ...
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.
