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
Director – eDominer Systems, Peopleware India, SQLMaestros

Follow me on Twitter | Follow me on FaceBook | Connect on LinkedIn | Google+
FB page | Know more about me

SQL Server Training, SQL Performance Tuning, Bangalore January 2014
SQL Server Lock Escalation explained