หมายเหตุ
การเข้าถึงหน้านี้ต้องได้รับการอนุญาต คุณสามารถลอง ลงชื่อเข้าใช้หรือเปลี่ยนไดเรกทอรีได้
การเข้าถึงหน้านี้ต้องได้รับการอนุญาต คุณสามารถลองเปลี่ยนไดเรกทอรีได้
Applies to: 
Azure Synapse Analytics
This article lists the Azure Synapse Analytics dynamic management objects.
All Azure Synapse Analytics dynamic management objects begin with sys.dm_pdw.
Note
This syntax is not supported by serverless SQL pool in Azure Synapse Analytics.
| Dynamic management object | Description |
|---|---|
| sys.dm_pdw_dms_cores | Returns all DMS services running on the Compute nodes of the appliance, one row per service instance. |
| sys.dm_pdw_dms_external_work | Returns all Data Movement Service (DMS) steps for external operations. |
| sys.dm_pdw_dms_workers | Returns all workers completing DMS steps. |
| sys.dm_pdw_errors | Returns all errors encountered during execution of a request or query. |
| sys.dm_pdw_exec_connections | Returns the connections established to this Azure Synapse Analytics instance, and the details of each connection. |
| sys.dm_pdw_exec_requests | Returns all requests currently or recently active, one row per request or query. |
| sys.dm_pdw_exec_sessions | Returns all sessions currently or recently open, one row per session. |
| sys.dm_pdw_hadoop_operations | Returns one row for each map-reduce job pushed down to Hadoop when running a query on an external Hadoop table. |
| sys.dm_pdw_lock_waits | Returns requests that are waiting for locks. |
| sys.dm_pdw_nodes_database_encryption_keys | Returns the encryption state of a database and its database encryption keys, for each node. |
| sys.dm_pdw_nodes_exec_query_plan | Returns the Showplan in XML format for the batch specified by the plan handle. |
| sys.dm_pdw_nodes_exec_query_profiles | Monitors real time data warehouse query progress while the query executes. |
| sys.dm_pdw_nodes_exec_query_statistics_xml | Returns the query execution plan for in-flight requests, with showplan XML and transient statistics. |
| sys.dm_pdw_nodes_exec_sql_text | Returns the text of the SQL batch identified by the specified sql_handle. |
| sys.dm_pdw_nodes_exec_text_query_plan | Returns the Showplan in text format for a Transact-SQL batch or for a specific statement within the batch. |
| sys.dm_pdw_nodes | Returns all nodes in the appliance, one row per node. |
| sys.dm_pdw_os_threads | Returns the operating system threads running on the nodes. |
| sys.dm_pdw_request_steps | Returns all steps that compose a given request or query, one row per query step. |
| sys.dm_pdw_resource_waits | Returns wait information for all resource types. |
| sys.dm_pdw_sql_requests | Returns all SQL Server query distributions that are part of a SQL step in the query. |
| sys.dm_pdw_sys_info | Returns appliance-level counters that reflect overall activity on the appliance. |
| sys.dm_pdw_wait_stats | Returns the SQL Server OS state for instances running on the different nodes. |
| sys.dm_pdw_waits | Returns all wait states encountered during execution of a request or query, including locks and waits on transmission queues. |
| sys.dm_workload_management_workload_groups_stats (Preview) | Returns workload group statistics and the effective values of the workload group. |