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.

Related content

• PolyBase troubleshooting with dynamic management views
• System dynamic management views and functions
• Database related dynamic management views (Transact-SQL)