New DMVs in SQL Server 2014 CTP1

When you download and start playing with SQL Server 2014 CTP1, here’s a few of the new instrumentation tables and views: New Internal Tables plan_persist_context_settings plan_persist_plan – Hey, lookie there! Implies that we can persist execution plans beyond a SQL Server service restart. plan_persist_query plan_persist_query_text plan_persist_runtime_stats plan_persist_runtime_stats_interval New Views column_store_row_groups dm_db_merge_requests dm_db_xtp_checkpoint – Note that both…
Read More