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

Execution Related Dynamic Management Views and Functions

Updated: 12 December 2006

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_plans

sys.dm_exec_cached_plan_dependent_objects

sys.dm_exec_connections

sys.dm_exec_cursors

sys.dm_exec_plan_attributes

sys.dm_exec_query_memory_grants

sys.dm_exec_query_optimizer_info

sys.dm_exec_query_plan

sys.dm_exec_query_resource_semaphores

sys.dm_exec_query_stats

sys.dm_exec_requests

sys.dm_exec_sessions

sys.dm_exec_sql_text

sys.dm_exec_text_query_plan

sys.dm_exec_xml_handles

 

ms188068.note(en-US,SQL.90).gifNote:
The sys.dm_exec_query_transformation_stats dynamic management view is for internal use only.

Release History

12 December 2006

Changed content:
  • Added sys.dm_exec_text_query_plan to the list of dynamic management objects.

14 April 2006

Changed content:
  • Added sys.dm_exec_query_memory_grants and sys.dm_exec_query_resource_semaphores to the list of dynamic management objects.

Community Additions

ADD
Show:
© 2015 Microsoft