Here is a link to a great virtual conference on SQL Server DMVs. The speakers…
I could not get the DAC going on the new Denali, so I can’t tell if there are some objects available only through it, but from what I can see, there are 20 new DMVs in Denali.
Here they are:
| name | type_desc |
| dm_db_objects_disabled_on_compatibility_level_change | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dm_db_uncontained_entities | VIEW |
| dm_exec_describe_first_result_set | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dm_exec_describe_first_result_set_for_object | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dm_fts_index_keywords_by_property | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dm_hadr_availability_group_states | VIEW |
| dm_hadr_availability_replica_states | VIEW |
| dm_hadr_database_replica_states | VIEW |
| dm_hadr_database_synchronization_states | VIEW |
| dm_hadr_instance_node_map | VIEW |
| dm_hadr_name_id_map | VIEW |
| dm_logconsumer_cachebufferrefs | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dm_logconsumer_privatecachebuffers | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dm_logpool_consumers | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dm_logpool_hashentries | VIEW |
| dm_logpool_sharedcachebuffers | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dm_logpool_stats | VIEW |
| dm_logpoolmgr_freepools | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dm_logpoolmgr_respoolsize | SQL_INLINE_TABLE_VALUED_FUNCTION |
| dm_logpoolmgr_stats | SQL_INLINE_TABLE_VALUED_FUNCTION |
So, this all sounds good and exciting, but since there is no documentation yet, I can only guess what they do. Here is how you can get a list of the DMVs in Denali: SELECT name, type_desc FROM sys.system_objects WHERE name LIKE ‘dm_%’