แก้ไข

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

Applies to: SQL Server

This section contains the following dynamic management objects:

sys.dm_exec_background_job_queue

sys.dm_exec_cached_plan_dependent_objects

sys.dm_exec_compute_node_errors

sys.dm_exec_compute_nodes

sys.dm_exec_cursors

sys.dm_exec_describe_first_result_set_for_object

sys.dm_exec_distributed_requests

sys.dm_exec_dms_services

sys.dm_exec_external_operations

sys.dm_exec_function_stats

sys.dm_exec_plan_attributes

sys.dm_exec_query_memory_grants

sys.dm_exec_query_optimizer_memory_gateways

sys.dm_exec_query_parallel_workers

sys.dm_exec_query_resource_semaphores

sys.dm_exec_query_stats

sys.dm_exec_requests

sys.dm_exec_sessions

sys.dm_exec_text_query_plan

sys.dm_exec_valid_use_hints

sys.dm_external_script_execution_stats

sys.dm_exec_background_job_queue_stats

sys.dm_exec_cached_plans

sys.dm_exec_compute_node_status

sys.dm_exec_connections

sys.dm_exec_describe_first_result_set

sys.dm_exec_distributed_request_steps

sys.dm_exec_distributed_sql_requests

sys.dm_exec_dms_workers

sys.dm_exec_external_work

sys.dm_exec_input_buffer

sys.dm_exec_procedure_stats

sys.dm_exec_query_optimizer_info

sys.dm_exec_query_plan

sys.dm_exec_query_profiles

sys.dm_exec_query_statistics_xml

sys.dm_exec_query_plan_stats

sys.dm_exec_session_wait_stats

sys.dm_exec_sql_text

sys.dm_exec_trigger_stats

sys.dm_exec_xml_handles

sys.dm_external_script_requests

Note

The sys.dm_exec_query_transformation_stats dynamic management view is identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

This section contains Azure Synapse Analytics dynamic management views (DMVs):

sys.dm_pdw_dms_cores

sys.dm_pdw_dms_external_work

sys.dm_pdw_dms_workers

sys.dm_pdw_errors

sys.dm_pdw_exec_connections

sys.dm_pdw_exec_requests

sys.dm_pdw_exec_sessions

sys.dm_pdw_nodes_exec_query_plan

sys.dm_pdw_nodes_exec_query_profiles

sys.dm_pdw_nodes_exec_query_statistics_xml

sys.dm_pdw_nodes_exec_sql_text

sys.dm_pdw_nodes_exec_text_query_plan

sys.dm_pdw_hadoop_operations

sys.dm_pdw_query_stats_xe

sys.dm_pdw_query_stats_xe_file

sys.dm_pdw_request_steps

sys.dm_pdw_sql_requests

  • Last updated on