This topic has not yet been rated - Rate this topic

Execution Related Dynamic Management Views and Functions

SQL Server 2005

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

Note:
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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions