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: 

nametype_desc
dm_db_objects_disabled_on_compatibility_level_changeSQL_INLINE_TABLE_VALUED_FUNCTION
dm_db_uncontained_entitiesVIEW
dm_exec_describe_first_result_setSQL_INLINE_TABLE_VALUED_FUNCTION
dm_exec_describe_first_result_set_for_objectSQL_INLINE_TABLE_VALUED_FUNCTION
dm_fts_index_keywords_by_propertySQL_INLINE_TABLE_VALUED_FUNCTION
dm_hadr_availability_group_statesVIEW
dm_hadr_availability_replica_statesVIEW
dm_hadr_database_replica_statesVIEW
dm_hadr_database_synchronization_statesVIEW
dm_hadr_instance_node_mapVIEW
dm_hadr_name_id_mapVIEW
dm_logconsumer_cachebufferrefsSQL_INLINE_TABLE_VALUED_FUNCTION
dm_logconsumer_privatecachebuffersSQL_INLINE_TABLE_VALUED_FUNCTION
dm_logpool_consumersSQL_INLINE_TABLE_VALUED_FUNCTION
dm_logpool_hashentriesVIEW
dm_logpool_sharedcachebuffersSQL_INLINE_TABLE_VALUED_FUNCTION
dm_logpool_statsVIEW
dm_logpoolmgr_freepoolsSQL_INLINE_TABLE_VALUED_FUNCTION
dm_logpoolmgr_respoolsizeSQL_INLINE_TABLE_VALUED_FUNCTION
dm_logpoolmgr_statsSQL_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_%’