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!