Hi Friends,

In this post, I am demonstrating how you can figure out SQL Server 2014 new DMV, yourself!

From SQL Server 2014 VM (or a physical box), add a Linked Server connection to a SQL Server 2012 VM (or a physical box)

And execute the following script:

SELECT a.NAME sql2014
    ,b.NAME
FROM sys.sysobjects a
LEFT JOIN [WIN2K8R2\SQL2012SP1].master.sys.sysobjects b ON a.NAME = b.NAME
WHERE a.NAME LIKE 'dm%'
    AND b.NAME IS NULL

And you get the list. You now know where you need to go to find more about each one of them 🙂

dm_db_stats_properties_internal

dm_db_xtp_checkpoint_files

dm_db_xtp_checkpoint_stats

dm_db_xtp_gc_cycle_stats

dm_db_xtp_hash_index_stats

dm_db_xtp_index_stats

dm_db_xtp_memory_consumers

dm_db_xtp_merge_requests

dm_db_xtp_nonclustered_index_stats

dm_db_xtp_object_stats

dm_db_xtp_table_memory_stats

dm_db_xtp_transactions

dm_exec_query_profiles

dm_io_cluster_valid_path_names

dm_os_buffer_pool_extension_configuration

dm_resource_governor_resource_pool_volumes

dm_xtp_gc_queue_stats

dm_xtp_gc_stats

dm_xtp_system_memory_consumers

dm_xtp_threads

dm_xtp_transaction_recent_rows

dm_xtp_transaction_stats

Want to watch this in action? Watch here!

Data Platform Virtual Summit 2020

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin.

SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter