SQL Server

SQL Server 2025 vs 2022: What Changed in DMVs

18. 1. 2026

I recently compared SQL Server system DMVs between SQL Server 2022 (16.0.4225.2) and SQL Server 2025 (17.0.1000.7). I used Redgate SQL Compare to generate an HTML report, and in this post, I’m providing a summary of the changes made, including additions, deletions, and modifications.

See the full comparison: SQL_2022_To_2025_DMV_Comparison

How I built the comparison list

I exported the list of system views from the sys schema using the query below. I also filtered out anything under INFORMATION_SCHEMA because I wanted to focus on the “real” system catalog/DMV surface area.

SELECT * 
FROM [sys].[system_objects] [so] 
    INNER JOIN [sys].[schemas] [sch] ON [sch].[schema_id] = [so].[schema_id] 
WHERE [type] = 'V' AND [sch].[name] = 'sys';

Headline numbers

  • Added: 28
  • Removed: 6
  • Modified: 39
  • Identical: 565

These counts are straight from the SQL Compare report.

New system objects in SQL Server 2025 (added)

The most interesting additions fall into a few “themes”: newer query processing diagnostics, automatic tuning internals, memory/OS health visibility, governance/security metadata, and new metadata areas like JSON and vector indexing.

  • sys_dm_database_backup_lineage
  • sys_dm_db_information_protection_label_properties
  • sys_dm_db_internal_auto_tuning_create_index_recommendations
  • sys_dm_db_internal_auto_tuning_recommendation_impact_query_metrics
  • sys_dm_db_internal_auto_tuning_recommendation_metrics
  • sys_dm_db_internal_auto_tuning_workflows
  • sys_dm_db_internal_automatic_tuning_version
  • sys_dm_db_logical_index_corruptions
  • sys_dm_db_xtp_undeploy_status
  • sys_dm_exec_ce_feedback_cache
  • sys_dm_exec_distributed_tasks
  • sys_dm_external_governance_synchronizing_objects
  • sys_dm_external_policy_excluded_role_members
  • sys_dm_hadr_internal_availability_groups
  • sys_dm_hadr_internal_availability_replicas
  • sys_dm_io_network_traffic_stats
  • sys_dm_os_memory_allocations_filtered
  • sys_dm_os_memory_health_history
  • sys_dm_os_memory_nodes_processor_groups
  • sys_dm_os_parent_block_descriptors
  • sys_dm_pal_ring_buffers
  • sys_dm_server_managed_identities
  • sys_external_models
  • sys_external_table_schema_changed_mdsync
  • sys_information_protection_label_mapping
  • sys_json_index_paths
  • sys_json_indexes
  • sys_vector_indexes

System objects that disappeared in SQL Server 2025 (removed)

Only six objects were flagged as removed.

  • sys_dm_dw_locks
  • sys_dm_pal_spinlock_stats
  • sys_dm_pal_wait_stats
  • sys_dm_toad_tuning_zones
  • sys_dm_toad_work_item_handlers
  • sys_dm_toad_work_items

Modified objects (what changed, at a high level)

The report shows 39 modified objects. In practice, these changes are typically “column-level” updates to internal catalog tables and DMVs to support new features and diagnostics in SQL Server 2025.

  • Query processing and tuning: changes around query profiling and memory grants, plus new cardinality-estimation feedback exposure (sys_dm_exec_ce_feedback_cache is new, and related surfaces like sys_dm_exec_query_memory_grants show changes).
  • Query Store & plan feedback: system objects related to plan feedback/forcing locations are modified (sys_query_store_plan_feedback, sys_query_store_plan_forcing_locations).
  • Availability groups / HADR: both catalog views and DMVs around AGs are modified (sys_availability_groups, sys_dm_hadr_availability_replica_states, sys_dm_hadr_database_replica_states), and there are new “internal” HADR DMVs in 2025 (listed above).
  • Memory/OS internals: multiple sys_dm_os_* objects are modified, and new memory-health/history DMVs appear in 2025.
  • Governance and labeling: new information protection label mapping and governance-sync related surfaces appear, and existing governance DMVs are modified (sys_dm_external_governance_sync_state, sys_dm_database_external_governance_sync_state).
  • Core catalog internals: classic internal objects like sys_all_columns, sys_columns, sys_parameters, sys_stats, and “system_*” internals show updates, which is typical when a major version adds metadata flags and new engine behaviors.
0
8
Share:

Leave a Reply