United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2008

Product Documentation

SQL Server 2008 Books Online

Database Engine

Technical Reference

Transact-SQL Reference

System Views (Transact-SQL)

Dynamic Management Views and Functions (Transact-SQL)

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

sys.dm_exec_background_job_queue (Transact-SQL)

sys.dm_exec_background_job_queue_stats (Transact-SQL)

sys.dm_exec_cached_plans (Transact-SQL)

sys.dm_exec_cached_plan_dependent_objects (Transact-SQL)

sys.dm_exec_connections (Transact-SQL)

sys.dm_exec_cursors (Transact-SQL)

sys.dm_exec_plan_attributes (Transact-SQL)

sys.dm_exec_query_memory_grants (Transact-SQL)

sys.dm_exec_query_optimizer_info (Transact-SQL)

sys.dm_exec_query_plan (Transact-SQL)

sys.dm_exec_procedure_stats (Transact-SQL)

sys.dm_exec_query_resource_semaphores (Transact-SQL)

sys.dm_exec_query_stats (Transact-SQL)

sys.dm_exec_requests (Transact-SQL)

sys.dm_exec_sessions (Transact-SQL)

sys.dm_exec_sql_text (Transact-SQL)

sys.dm_exec_trigger_stats (Transact-SQL)

sys.dm_exec_text_query_plan (Transact-SQL)

sys.dm_exec_xml_handles (Transact-SQL)

Minimize

This topic has not yet been rated - Rate this topic

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

SQL Server 2008

This section contains the following dynamic management objects:

sys.dm_exec_background_job_queue (Transact-SQL)	sys.dm_exec_query_optimizer_info (Transact-SQL)
sys.dm_exec_background_job_queue (Transact-SQL)	sys.dm_exec_query_plan (Transact-SQL)
sys.dm_exec_background_job_queue_stats (Transact-SQL)	sys.dm_exec_query_resource_semaphores (Transact-SQL)
sys.dm_exec_cached_plans (Transact-SQL)	sys.dm_exec_query_stats (Transact-SQL)
sys.dm_exec_cached_plan_dependent_objects (Transact-SQL)	sys.dm_exec_requests (Transact-SQL)
sys.dm_exec_connections (Transact-SQL)	sys.dm_exec_sessions (Transact-SQL)
sys.dm_exec_cursors (Transact-SQL)	sys.dm_exec_sql_text (Transact-SQL)
sys.dm_exec_plan_attributes (Transact-SQL)	sys.dm_exec_text_query_plan (Transact-SQL)
sys.dm_exec_procedure_stats (Transact-SQL)	sys.dm_exec_trigger_stats (Transact-SQL)
sys.dm_exec_query_memory_grants (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.

Reference

Dynamic Management Views and Functions (Transact-SQL)

System Views (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.