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

title	sys.dm_pdw_dms_workers (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/07/2017
ms.prod
ms.prod_service	sql-data-warehouse, pdw
ms.reviewer
ms.topic	language-reference
dev_langs	TSQL
ms.assetid	0a284d18-3c46-4ffa-bcc9-689e660ee8b4
author	ronortloff
ms.author	rortloff
manager	craigg
monikerRange	>= aps-pdw-2016 || = azure-sqldw-latest || = sqlallproducts-allversions

sys.dm_pdw_dms_workers (Transact-SQL)

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

Holds information about all workers completing DMS steps.

Column Name	Data Type	Description	Range
request_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.	See request_id in sys.dm_pdw_exec_requests (Transact-SQL).
step_index	int	Query step this DMS worker is part of. request_id, step_index, and dms_step_index form the key for this view.	See step_index in sys.dm_pdw_request_steps (Transact-SQL).
dms_step_index	int	Step in the DMS plan that this worker is running. request_id, step_index, and dms_step_index form the key for this view.
pdw_node_id	int	Node that the worker is running on.	See node_id in sys.dm_pdw_nodes (Transact-SQL).
distribution_id	Int	Distribution that the worker is running on, if any.	See distribution_id in sys.pdw_distributions (Transact-SQL).
type	nvarchar(32)	Type of DMS worker thread this entry represents.	'DIRECT_CONVERTER', 'DIRECT_READER', 'FILE_READER', 'HASH_CONVERTER', 'HASH_READER', 'ROUNDROBIN_CONVERTER', 'EXPORT_READER', 'EXTERNAL_READER', 'EXTERNAL_WRITER', 'PARALLEL_COPY_READER', 'REJECT_WRITER', 'WRITER'
status	nvarchar(32)	Status of the DMS worker.	[!INCLUDEssInfoNA]
bytes_per_sec	bigint	Read or write throughput in the last second.	Greater than or equal to 0. NULL if the query was cancelled or failed before the worker could execute.
bytes_processed	bigint	Total bytes processed by this worker.	Greater than or equal to 0. NULL if the query was cancelled or failed before the worker could execute.
rows_processed	bigint	Number of rows read or written for this worker.	Greater than or equal to 0. NULL if the query was cancelled or failed before the worker could execute.
start_time	datetime	Time at which execution of this worker started.	Greater than or equal to start time of the query step this worker belongs to. See sys.dm_pdw_request_steps (Transact-SQL).
end_time	datetime	Time at which execution ended, failed, or was cancelled.	NULL for ongoing or queued workers. Otherwise, greater than start_time.
total_elapsed_time	int	Total time spent in execution, in milliseconds.	Greater than or equal to 0. Total time elapsed since system start or restart. If total_elapsed_time exceeds the maximum value for an integer (24.8 days in milliseconds), it will cause materialization failure due to overflow. The maximum value in milliseconds is equivalent to 24.8 days.
cpu_time	bigint	CPU time consumed by this worker, in milliseconds.	Greater than or equal to 0.
query_time	int	Period of time before SQL starts returning rows to the thread, in milliseconds.	Greater than or equal to 0.
buffers_available	int	Number of unused buffers.	NULL if the query was cancelled or failed before the worker could execute.
sql_spid	int	Session id on the SQL Server instance performing the work for this DMS worker.
dms_cpid	int	Process ID of the actual thread running.
error_id	nvarchar(36)	Unique identifier of the error that occurred during execution of this worker, if any.	See error_id in sys.dm_pdw_request_steps (Transact-SQL).
source_info	nvarchar(4000)	For a reader, specification of the source tables and columns.
destination_info	nvarchar(4000)	For a writer, specification of the destination tables.

For information about the maximum rows retained by this view, see Maximum System View Values.

See Also

SQL Data Warehouse and Parallel Data Warehouse Dynamic Management Views (Transact-SQL)