Execution Related Dynamic Management Views and Functions | Microsoft Learn

Article
2008-12-03

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.

See Also

Reference

Dynamic Management Views and Functions
System Views (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance

Change History

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.