sys.dm_exec_dms_services (Transact-SQL)
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)
Tilbakemeldinger
https://aka.ms/ContentUserFeedback.
Kommer snart: Gjennom 2024 faser vi ut GitHub Issues som tilbakemeldingsmekanisme for innhold, og erstatter det med et nytt system for tilbakemeldinger. Hvis du vil ha mer informasjon, kan du se:Send inn og vis tilbakemelding for