Tag Archives: List of DMV added in SQL Server 2011 (Denali)

What are the new DMV and DMF added in SQL Server 2011 ?

Here is the List of DMV’s (Dynamic Management Views) and DMF’s (Dynamic Management Functions) which are newly added in SQL Server Denali CTP-1 S.No DMV / DMF Name Type 1 dm_logpoolmgr_stats Function 2 dm_hadr_instance_node_map View 3 dm_db_objects_disabled_on_compatibility_level_change Function 4 dm_hadr_name_id_map View 5 dm_logpool_hashentries View 6 dm_logconsumer_cachebufferrefs Function 7 dm_hadr_availability_replica_states View 8 dm_logpool_consumers Function 9 dm_exec_describe_first_result_set_for_object [...]