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

 

Updated: November 17, 2016

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 (Transact-SQL)sys.dm_exec_function_stats (Transact-SQL)
sys.dm_exec_background_job_queue (Transact-SQL)sys.dm_exec_query_memory_grants (Transact-SQL)
sys.dm_exec_background_job_queue_stats (Transact-SQL)sys.dm_exec_query_optimizer_info (Transact-SQL)
sys.dm_exec_cached_plans (Transact-SQL)sys.dm_exec_query_statistics_xml (Transact-SQL)
sys.dm_exec_cached_plan_dependent_objects (Transact-SQL)sys.dm_exec_plan_attributes (Transact-SQL)
sys.dm_exec_connections (Transact-SQL)sys.dm_exec_procedure_stats (Transact-SQL)
sys.dm_exec_compute_node_errors (Transact-SQL)sys.dm_exec_query_plan (Transact-SQL)
sys.dm_exec_compute_node_status (Transact-SQL)sys.dm_exec_query_resource_semaphores (Transact-SQL)
sys.dm_exec_compute_nodes (Transact-SQL)sys.dm_exec_query_stats (Transact-SQL)
sys.dm_exec_cursors (Transact-SQL)sys.dm_exec_requests (Transact-SQL)
sys.dm_exec_describe_first_result_set (Transact-SQL)sys.dm_exec_sessions (Transact-SQL)
sys.dm_exec_describe_first_result_set_for_object (Transact-SQL)sys.dm_exec_session_wait_stats (Transact-SQL)
sys.dm_exec_distributed_request_steps (Transact-SQL)sys.dm_exec_sql_text (Transact-SQL)
sys.dm_exec_distributed_requests (Transact-SQL)sys.dm_exec_text_query_plan (Transact-SQL)
sys.dm_exec_distributed_sql_requests (Transact-SQL)sys.dm_exec_trigger_stats (Transact-SQL)
sys.dm_exec_dms_services (Transact-SQL)sys.dm_exec_valid_use_hints (Transact-SQL)
sys.dm_exec_dms_workers (Transact-SQL)sys.dm_exec_xml_handles (Transact-SQL)
sys.dm_exec_external_operations (Transact-SQL)sys.dm_external_script_execution_stats
sys.dm_exec_external_work (Transact-SQL)sys.dm_external_script_requests
System_CAPS_ICON_note.jpg Note


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

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

Community Additions

ADD
Show: