Execution Related Dynamic Management Views and Functions (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

This section contains the following dynamic management objects:

sys.dm_exec_background_job_queue sys.dm_exec_background_job_queue_stats
sys.dm_exec_cached_plan_dependent_objects sys.dm_exec_cached_plans
sys.dm_exec_compute_node_errors sys.dm_exec_compute_node_status
sys.dm_exec_compute_nodes sys.dm_exec_connections
sys.dm_exec_cursors sys.dm_exec_describe_first_result_set
sys.dm_exec_describe_first_result_set_for_object sys.dm_exec_distributed_request_steps
sys.dm_exec_distributed_requests sys.dm_exec_distributed_sql_requests
sys.dm_exec_dms_services sys.dm_exec_dms_workers
sys.dm_exec_external_operations sys.dm_exec_external_work
sys.dm_exec_function_stats sys.dm_exec_input_buffer
sys.dm_exec_plan_attributes sys.dm_exec_procedure_stats
sys.dm_exec_query_memory_grants sys.dm_exec_query_optimizer_info
sys.dm_exec_query_plan sys.dm_exec_query_profiles
sys.dm_exec_query_resource_semaphores sys.dm_exec_query_statistics_xml
sys.dm_exec_query_stats sys.dm_exec_requests
sys.dm_exec_session_wait_stats sys.dm_exec_sessions
sys.dm_exec_sql_text sys.dm_exec_text_query_plan
sys.dm_exec_trigger_stats sys.dm_exec_valid_use_hints
sys.dm_exec_xml_handles sys.dm_external_script_execution_stats
sys.dm_external_script_requests
Note

The sys.dm_exec_query_transformation_stats dynamic management view is identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

See Also

Dynamic Management Views and Functions (Transact-SQL)
System Views (Transact-SQL)