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:
© 2014 Microsoft