Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server 2016 (13.x) and later versions
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 | |
| compute_pool_id | int |
Unique identifier for the pool. |
See Also
PolyBase troubleshooting with dynamic management views
Dynamic Management Views and Functions (Transact-SQL)
Database Related Dynamic Management Views (Transact-SQL)