execution-related-dynamic-management-views-and-functions-transact-sql.md

title	Execution Related Dynamic Management Views and Functions (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/27/2019
ms.prod	sql
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
dev_langs	TSQL
helpviewer_keywords	dynamic management objects [SQL Server], execution execution-related dynamic management objects [SQL Server]
ms.assetid	aea07b33-f715-4b61-9d1e-8c77b03e9578
author	stevestein
ms.author	sstein

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

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

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_optimizer_memory_gateways	sys.dm_exec_query_plan
sys.dm_exec_query_parallel_workers	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_query_plan_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)