New DMVs in Denali

Oopps! Upgrade your browser pretty please. Oopps! Upgrade your browser pretty please.

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_%’