List of DMV and DMF availability across all SQL Server Versions

Leave a comment (0) Go to comments

This is the extensive list of ALL Dynamic Management Views (DMV) and Dynamic Management Functions (DMF) which are available across Versions and Editions.

This List Answers:

  1. DMV in SQL Server 2005
  2. DMV newly added in SQL Server 2008
  3. DMV removed in SQL Server 2008
  4. DMV newly added in SQL Server 2008 R2
  5. DMV removed in SQL Server 2008 R2
  6. DMV newly added in SQL Server Denali CTP1 (2011)
  7. DMV removed in SQL Server 2008 Denali CTP1 (2011)

Legends used in Table:

 

Avail

Available


N/A

Not Available

V

Dynamic Management View DMV

F

Dynamic Management Function DMF

Detailed List of DMV and DMF

 

Name

DenaliCTP1

2008
R2

2008

2005

Type

dm_os_hosts

Avail

Avail

Avail

Avail

V

dm_os_memory_brokers

Avail

Avail

Avail

N / A

V

dm_exec_cached_plan_dependent_objects

Avail

Avail

Avail

Avail

F

dm_os_memory_allocations

Avail

Avail

Avail

Avail

V

dm_db_mirroring_past_actions

Avail

Avail

Avail

N / A

V

dm_xe_session_object_columns

Avail

Avail

Avail

N / A

V

dm_os_loaded_modules

Avail

Avail

Avail

Avail

V

dm_db_task_space_usage

Avail

Avail

Avail

Avail

V

dm_os_memory_objects

Avail

Avail

Avail

Avail

V

dm_audit_class_type_map

Avail

Avail

Avail

N / A

V

dm_logpoolmgr_stats

Avail

N / A

N / A

N / A

F

dm_os_schedulers

Avail

Avail

Avail

Avail

V

dm_hadr_instance_node_map

Avail

N / A

N / A

N / A

V

dm_os_dispatcher_pools

Avail

Avail

Avail

N / A

V

dm_os_threads

Avail

Avail

Avail

Avail

V

dm_db_objects_disabled_on_compatibility_level_change

Avail

N / A

N / A

N / A

F

dm_exec_requests

Avail

Avail

Avail

Avail

V

dm_fts_parser

Avail

Avail

Avail

N / A

F

dm_tran_commit_table

Avail

Avail

Avail

N / A

V

dm_cryptographic_provider_keys

Avail

Avail

Avail

N / A

F

dm_fts_outstanding_batches

Avail

Avail

Avail

N / A

V

dm_db_missing_index_columns

Avail

Avail

Avail

Avail

F

dm_repl_tranhash

Avail

Avail

Avail

Avail

V

dm_qn_subscriptions

Avail

Avail

Avail

Avail

V

dm_db_session_space_usage

Avail

Avail

Avail

Avail

V

dm_exec_query_optimizer_info

Avail

Avail

Avail

Avail

V

dm_xe_map_values

Avail

Avail

Avail

N / A

V

dm_tran_top_version_generators

Avail

Avail

Avail

Avail

V

dm_fts_fdhosts

Avail

Avail

Avail

N / A

V

dm_xe_sessions

Avail

Avail

Avail

N / A

V

dm_hadr_name_id_map

Avail

N / A

N / A

N / A

V

dm_os_waiting_tasks

Avail

Avail

Avail

Avail

V

dm_exec_background_job_queue

Avail

Avail

Avail

Avail

V

dm_exec_cursors

Avail

Avail

Avail

Avail

F

dm_db_missing_index_details

Avail

Avail

Avail

Avail

V

dm_clr_properties

Avail

Avail

Avail

Avail

V

dm_os_sublatches

Avail

Avail

Avail

Avail

V

dm_exec_query_memory_grants

Avail

Avail

Avail

N / A

V

dm_fts_index_keywords

Avail

Avail

Avail

N / A

F

dm_logpool_hashentries

Avail

N / A

N / A

N / A

V

dm_logconsumer_cachebufferrefs

Avail

N / A

N / A

N / A

F

dm_tran_current_snapshot

Avail

Avail

Avail

Avail

V

dm_io_virtual_file_stats

Avail

Avail

Avail

Avail

F

dm_exec_xml_handles

Avail

Avail

Avail

N / A

F

dm_os_wait_stats

Avail

Avail

Avail

Avail

V

dm_os_memory_node_access_stats

Avail

Avail

Avail

N / A

V

dm_os_spinlock_stats

Avail

Avail

Avail

N / A

V

dm_database_encryption_keys

Avail

Avail

Avail

N / A

V

dm_exec_text_query_plan

Avail

Avail

Avail

N / A

F

dm_hadr_availability_replica_states

Avail

N / A

N / A

N / A

V

dm_broker_connections

Avail

Avail

Avail

Avail

V

dm_db_mirroring_auto_page_repair

Avail

Avail

Avail

N / A

V

dm_logpool_consumers

Avail

N / A

N / A

N / A

F

dm_os_dispatchers

Avail

Avail

Avail

N / A

V

dm_exec_describe_first_result_set_for_object

Avail

N / A

N / A

N / A

F

dm_os_stacks

Avail

Avail

Avail

Avail

V

dm_xe_session_targets

Avail

Avail

Avail

N / A

V

dm_sql_referencing_entities

Avail

Avail

Avail

N / A

F

dm_audit_actions

Avail

Avail

Avail

N / A

V

dm_hadr_availability_group_states

Avail

N / A

N / A

N / A

V

dm_os_ring_buffers

Avail

Avail

Avail

Avail

V

dm_db_missing_index_groups

Avail

Avail

Avail

Avail

V

dm_db_uncontained_entities

Avail

N / A

N / A

N / A

V

dm_exec_cached_plans

Avail

Avail

Avail

Avail

V

dm_exec_sessions

Avail

Avail

Avail

Avail

V

dm_resource_governor_resource_pools

Avail

Avail

Avail

N / A

V

dm_os_memory_clerks

Avail

Avail

Avail

Avail

V

dm_repl_articles

Avail

Avail

Avail

Avail

V

dm_xe_session_events

Avail

Avail

Avail

N / A

V

dm_logpoolmgr_freepools

Avail

N / A

N / A

N / A

F

dm_fts_memory_buffers

Avail

Avail

Avail

Avail

V

dm_fts_index_population

Avail

Avail

Avail

Avail

V

dm_tran_current_transaction

Avail

Avail

Avail

Avail

V

dm_os_child_instances

Avail

Avail

Avail

Avail

V

dm_exec_connections

Avail

Avail

Avail

Avail

V

dm_exec_background_job_queue_stats

Avail

Avail

Avail

Avail

V

dm_filestream_file_io_handles

Avail

Avail

Avail

N / A

V

dm_fts_active_catalogs

Avail

Avail

Avail

Avail

V

dm_tran_database_transactions

Avail

Avail

Avail

Avail

V

dm_filestream_file_io_requests

Avail

Avail

Avail

N / A

V

dm_cdc_log_scan_sessions

Avail

Avail

Avail

N / A

V

dm_os_memory_cache_clock_hands

Avail

Avail

Avail

Avail

V

dm_repl_schemas

Avail

Avail

Avail

Avail

V

dm_db_mirroring_connections

Avail

Avail

Avail

Avail

V

dm_db_index_operational_stats

Avail

Avail

Avail

Avail

F

dm_db_partition_stats

Avail

Avail

Avail

Avail

V

dm_cryptographic_provider_sessions

Avail

Avail

Avail

N / A

F

dm_os_sys_memory

Avail

Avail

Avail

N / A

V

dm_sql_referenced_entities

Avail

Avail

Avail

N / A

F

dm_io_pending_io_requests

Avail

Avail

Avail

Avail

V

dm_os_nodes

Avail

Avail

Avail

N / A

V

dm_os_memory_cache_entries

Avail

Avail

Avail

Avail

V

dm_os_virtual_address_dump

Avail

Avail

Avail

Avail

V

dm_exec_describe_first_result_set

Avail

N / A

N / A

N / A

F

dm_cryptographic_provider_properties

Avail

Avail

Avail

N / A

V

dm_tran_transactions_snapshot

Avail

Avail

Avail

Avail

V

dm_exec_query_plan

Avail

Avail

Avail

Avail

F

dm_os_memory_cache_hash_tables

Avail

Avail

Avail

Avail

V

dm_cdc_errors

Avail

Avail

Avail

N / A

V

dm_hadr_database_synchronization_states

Avail

N / A

N / A

N / A

V

dm_resource_governor_configuration

Avail

Avail

Avail

N / A

V

dm_exec_query_stats

Avail

Avail

Avail

Avail

V

dm_clr_tasks

Avail

Avail

Avail

Avail

V

dm_os_worker_local_storage

Avail

Avail

Avail

Avail

V

dm_db_persisted_sku_features

Avail

Avail

Avail

N / A

V

dm_logpoolmgr_respoolsize

Avail

N / A

N / A

N / A

F

dm_db_index_usage_stats

Avail

Avail

Avail

Avail

V

dm_db_index_physical_stats

Avail

Avail

Avail

Avail

F

dm_os_buffer_descriptors

Avail

Avail

Avail

Avail

V

dm_tran_active_snapshot_database_transactions

Avail

Avail

Avail

Avail

V

dm_fts_index_keywords_by_document

Avail

Avail

Avail

N / A

F

dm_logpool_sharedcachebuffers

Avail

N / A

N / A

N / A

F

dm_tran_active_transactions

Avail

Avail

Avail

Avail

V

dm_db_file_space_usage

Avail

Avail

Avail

Avail

V

dm_broker_activated_tasks

Avail

Avail

Avail

Avail

V

dm_broker_queue_monitors

Avail

Avail

Avail

Avail

V

dm_os_memory_cache_counters

Avail

Avail

Avail

Avail

V

dm_tran_session_transactions

Avail

Avail

Avail

Avail

V

dm_clr_appdomains

Avail

Avail

Avail

Avail

V

dm_exec_sql_text

Avail

Avail

Avail

Avail

F

dm_fts_index_keywords_by_property

Avail

N / A

N / A

N / A

F

dm_exec_trigger_stats

Avail

Avail

N / A

N / A

V

dm_os_memory_pools

Avail

Avail

Avail

Avail

V

dm_os_latch_stats

Avail

Avail

Avail

Avail

V

dm_io_backup_tapes

Avail

Avail

Avail

Avail

V

dm_resource_governor_workload_groups

Avail

Avail

Avail

N / A

V

dm_hadr_database_replica_states

Avail

N / A

N / A

N / A

V

dm_fts_memory_pools

Avail

Avail

Avail

Avail

V

dm_os_sys_info

Avail

Avail

Avail

Avail

V

dm_tran_locks

Avail

Avail

Avail

Avail

V

dm_exec_procedure_stats

Avail

Avail

Avail

N / A

V

dm_exec_query_transformation_stats

Avail

Avail

Avail

Avail

V

dm_exec_query_resource_semaphores

Avail

Avail

Avail

N / A

V

dm_repl_traninfo

Avail

Avail

Avail

Avail

V

dm_cryptographic_provider_algorithms

Avail

Avail

Avail

N / A

F

dm_db_missing_index_group_stats

Avail

Avail

Avail

Avail

V

dm_fts_population_ranges

Avail

Avail

Avail

Avail

V

dm_os_performance_counters

Avail

Avail

Avail

Avail

V

dm_os_workers

Avail

Avail

Avail

Avail

V

dm_xe_session_event_actions

Avail

Avail

Avail

N / A

V

dm_logconsumer_privatecachebuffers

Avail

N / A

N / A

N / A

F

dm_db_script_level

Avail

Avail

Avail

N / A

V

dm_server_audit_status

Avail

Avail

Avail

N / A

V

dm_io_cluster_shared_drives

Avail

Avail

Avail

Avail

V

dm_os_tasks

Avail

Avail

Avail

Avail

V

dm_exec_plan_attributes

Avail

Avail

Avail

Avail

F

dm_xe_packages

Avail

Avail

Avail

N / A

V

dm_logpool_stats

Avail

N / A

N / A

N / A

V

dm_os_memory_nodes

Avail

Avail

Avail

N / A

V

dm_tran_version_store

Avail

Avail

Avail

Avail

V

dm_os_cluster_nodes

Avail

Avail

Avail

Avail

V

dm_os_process_memory

Avail

Avail

Avail

N / A

V

dm_xe_objects

Avail

Avail

Avail

N / A

V

dm_xe_object_columns

Avail

Avail

Avail

N / A

V

dm_clr_loaded_assemblies

Avail

Avail

Avail

Avail

V

dm_broker_forwarded_messages

N/A

Avail

Avail

Avail

V


Legends:

 

Avail

Availbale

N/A

Not Available

V

Dynamic Management View DMV

F

Dynamic Management Fuction DMF

EOF - List of DMV and DMF availability across all SQL Server Versions, 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.