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

title	sys.dm_exec_dms_workers (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	SYS.DM_EXEC_DMS_WORKERS_TSQL DM_EXEC_DMS_WORKERS_TSQL DM_EXEC_DMS_WORKERS
dev_langs	TSQL
helpviewer_keywords	PolyBase,views PolyBase dm_exec_dms_workers management view sys.dm_exec_dms_workers management view
ms.assetid	f468da29-78c3-4f10-8a3c-17905bbf46f2
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_workers (Transact-SQL)

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

Holds information about all workers completing DMS steps.

This view shows the data for the last 1000 requests and active requests; active requests always have the data present in this view.

Column Name	Data Type	Description	Range
execution_id	nvarchar(32)	Query that this DMS worker is part of.request_id, step_index, and dms_step_index form the key for this view.
step_index	int	Query step this DMS worker is part of.	See step index in sys.dm_exec_distributed_request_steps (Transact-SQL).
dms_step_index	int	Step in the DMS plan that this worker is running.	See sys.dm_exec_dms_workers (Transact-SQL)
compute_node_id	int	Node that the worker is running on.	See sys.dm_exec_compute_nodes (Transact-SQL).
distribution_id	int
type	nvarcha(32)
status	nvarchar(32)	Status of this step	'Pending', 'Running', 'Complete', 'Failed', 'UndoFailed', 'PendingCancel', 'Cancelled', 'Undone', 'Aborted'
bytes_per_sec	bigint
bytes_processed	bigint
rows_processed	bigint
start_time	datetime	Time at which the step started execution	Smaller or equal to current time and larger or equal to end_compile_time of the query to which this step belongs.
end_time	datetime	Time at which this step completed execution, was cancelled, or failed.	Smaller or equal to current time and larger or equal to start_time, set to NULL for steps currently in execution or queued.
total_elapsed_time	int	Total amount of time the query step has been executing, in milliseconds	Between 0 and the difference between end_time and start_time. 0 for queued steps.
cpu_time	bigint
query_time	int
buffers_available	int
dms_cpid	int
sql_spid	int
error_id	nvarchar(36)
source_info	nvarchar(4000)
destination_info	nvarchar(4000)
command	nvarchar(4000)
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)