sys.dm_pdw_dms_cores (Transact-SQL)

APPLIES TO: noSQL Server noAzure SQL Database yesAzure Synapse Analytics (SQL DW) yesParallel Data Warehouse

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.

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

SQL Data Warehouse and Parallel Data Warehouse Dynamic Management Views (Transact-SQL)