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)