Skip to main content

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

Download Microsoft Edge More info about Internet Explorer and Microsoft Edge
Read in English
Read in English
Twitter LinkedIn Facebook Email

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

  • Article
  • 05/16/2013

In this article

This section contains the following dynamic management objects:

sys.dm_exec_background_job_queue (Transact-SQL)

sys.dm_exec_query_memory_grants (Transact-SQL)

sys.dm_exec_background_job_queue (Transact-SQL)

sys.dm_exec_query_optimizer_info (Transact-SQL)

sys.dm_exec_background_job_queue_stats (Transact-SQL)

sys.dm_exec_query_plan (Transact-SQL)

sys.dm_exec_cached_plans (Transact-SQL)

sys.dm_exec_query_resource_semaphores (Transact-SQL)

sys.dm_exec_cached_plan_dependent_objects (Transact-SQL)

sys.dm_exec_query_stats (Transact-SQL)

sys.dm_exec_connections (Transact-SQL)

sys.dm_exec_requests (Transact-SQL)

sys.dm_exec_cursors (Transact-SQL)

sys.dm_exec_sessions (Transact-SQL)

sys.dm_exec_describe_first_result_set (Transact-SQL)

sys.dm_exec_sql_text (Transact-SQL)

sys.dm_exec_describe_first_result_set_for_object (Transact-SQL)

sys.dm_exec_text_query_plan (Transact-SQL)

sys.dm_exec_plan_attributes (Transact-SQL)

sys.dm_exec_trigger_stats (Transact-SQL)

sys.dm_exec_procedure_stats (Transact-SQL)

sys.dm_exec_xml_handles (Transact-SQL)

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

Reference

Dynamic Management Views and Functions (Transact-SQL)

System Views (Transact-SQL)


Additional resources

  • Previous Versions
  • Blog
  • Contribute
  • Privacy
  • Terms of Use
  • Trademarks
  • © Microsoft 2023

Additional resources

In this article

  • Previous Versions
  • Blog
  • Contribute
  • Privacy
  • Terms of Use
  • Trademarks
  • © Microsoft 2023