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:

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!

 

Amit Bansal (SQL MCM, SQL MVP) | Twitter | FaceBook | LinkedIn | FB Page|Ask a SQL Question                                                          Browse more blogs on SQLServerGeeks.com