Rediģēt

Kopīgot, izmantojot


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)