Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
Azure Synapse Analytics
Tip
Microsoft Fabric Data Warehouse is an enterprise scale relational warehouse on a data lake foundation, with a future-ready architecture, built-in AI, and new features. If you're new to data warehousing, start with Fabric Data Warehouse. Existing dedicated SQL pool workloads can upgrade to Fabric to access new capabilities across data science, real-time analytics, and reporting.
This article lists the Azure Synapse Analytics dynamic management objects.
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. |