sys-dm-exec-dms-services-transact-sql.md

title	sys.dm_exec_dms_services (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	11/04/2019
ms.prod	sql
ms.prod_service	database-engine, sql-data-warehouse, pdw
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	DM_EXEC_DMS_SERVICES_TSQL SYS.DM_EXEC_DMS_SERVICES_TSQL DM_EXEC_DMS_SERVICES
dev_langs	TSQL
helpviewer_keywords	PolyBase,views PolyBase dm_exec_dms_services management view sys.dm_exec_dms_services management view
ms.assetid	6ac47eef-4293-46b8-8555-07a614837504
author	stevestein
ms.author	sstein
monikerRange	>=aps-pdw-2016||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

sys.dm_exec_dms_services (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2016-xxxx-asdw-pdw-md]

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)