title: "sys.dm_exec_dms_services (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "03/15/2017" ms.prod: "sql" ms.prod_service: "database-engine, sql-data-warehouse, pdw" ms.service: "" ms.component: "dmv's" ms.reviewer: "" ms.suite: "sql" ms.technology:
- "database-engine" ms.tgt_pltfrm: "" 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 caps.latest.revision: 7 author: "stevestein" ms.author: "sstein" manager: "craigg" ms.workload: "Inactive" monikerRange: ">= aps-pdw-2016 || = azure-sqldw-latest || >= sql-server-2016 || = sqlallproducts-allversions"
[!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 |
PolyBase troubleshooting with dynamic management views
Dynamic Management Views and Functions (Transact-SQL)
Database Related Dynamic Management Views (Transact-SQL)