sys.dm_pdw_dms_cores (Transact-SQL)
Applies to: 
Azure Synapse Analytics
Analytics Platform System (PDW)
Holds information about all DMS services running on the Compute nodes of the appliance. It lists one row per service instance, which is currently one row per node.
Note
This syntax is not supported by serverless SQL pool in Azure Synapse Analytics.
| Column Name | Data Type | Description | Range |
|---|---|---|---|
| dms_core_id | int | Unique numeric id associated with this DMS core. Key for this view. |
Set to the pdw_node_id of the node that this DMS core is running on. |
| pdw_node_id | int | ID of the node on which this DMS service is running. | See node_id in sys.dm_pdw_nodes (Transact-SQL). |
| status | nvarchar(32) | Current status of the DMS service. | Information not available. |
For information about the maximum rows retained by this view, see the Metadata section in the Capacity limits topic.
See Also
Azure Synapse Analytics and Parallel Data Warehouse Dynamic Management Views (Transact-SQL)