Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

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

 

Updated: July 27, 2015

Applies To: SQL Server 2014, SQL Server 2016 Preview

This section contains the following dynamic management objects:

sys.dm_exec_background_job_queue (Transact-SQL)

sys.dm_exec_external_operations (Transact-SQL)

sys.dm_exec_background_job_queue (Transact-SQL)

sys.dm_exec_external_work (Transact-SQL)

sys.dm_exec_background_job_queue_stats (Transact-SQL)

sys.dm_exec_query_memory_grants (Transact-SQL)

sys.dm_exec_cached_plans (Transact-SQL)

sys.dm_exec_query_optimizer_info (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_xml_handles (Transact-SQL)

sys.dm_exec_dms_workers (Transact-SQL)

System_CAPS_noteNote

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

Community Additions

ADD
Show:
© 2015 Microsoft