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

Leave a comment (0) Go to comments

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 Function
10 dm_hadr_availability_group_states View
11 dm_db_uncontained_entities View
12 dm_logpoolmgr_freepools Function
13 dm_exec_describe_first_result_set Function
14 dm_hadr_database_synchronization_states View
15 dm_logpoolmgr_respoolsize Function
16 dm_logpool_sharedcachebuffers Function
17 dm_fts_index_keywords_by_property Function
18 dm_hadr_database_replica_states View
19 dm_logconsumer_privatecachebuffers Function
20 dm_logpool_stats View

Tags : List of DMV added in SQL Server 2011 (Denali),List of Dynamic Management Views added in SQL Server 2011 (Denali),List of DMF added in SQL Server 2011 (Denali),List of Dynamic Management Functions added in SQL Server 2011 (Denali)

EOF - What are the new DMV and DMF added in SQL Server 2011 ?, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.