With SQL Server Denali CTP1 come 20 new dynamic management views, this brings the total number of dynamic management views to 155

Here is a list of the new dynamic management views, included is also the type of the dynamic management view

DMV Name DMV Type
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

Unfortunately, when I downloaded this there was no documentation available yet, once documentation is available I will take a closer look at the new dynamic management views in Denali

If you would like a list of all dynamic management views in SQL Server Denali then run this query

T-SQL
1
2
select * from sysobjects
where name like 'dm[_]%'
select * from sysobjects
where name like 'dm[_]%'

In this post Playing around with sys.dm_exec_describe_first_result_set And sys.dm_exec_describe_first_result_set_for_object I am taking a quick look at two of those views

Click on the SQL Server Denali tag to see all our SQL Server Denali related posts