sys.dm_exec_dms_services (Transact-SQL)

APPLIES TO: yesSQL Server (starting with 2016) noAzure SQL Database yesAzure SQL Data Warehouse yesParallel Data Warehouse

Holds information about all of the DMS services running on the PolyBase compute nodes. It lists one row per service instance.

Column Name Data Type Description Range
dms_core_id int Unique numeric id associated with the DMS core. Key for this view. Unique ID.
compute_node_id int ID of the node on which this DMS service is running See compute_node_id in sys.dm_exec_compute_nodes (Transact-SQL).
status nvarchar(32) Current status of the DMS service

See Also

PolyBase troubleshooting with dynamic management views
Dynamic Management Views and Functions (Transact-SQL)
Database Related Dynamic Management Views (Transact-SQL)