Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft