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

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	dev_langs	monikerRange
sys.dm_pdw_dms_workers (Transact-SQL)	sys.dm_pdw_dms_workers (Transact-SQL)	WilliamDAssafMSFT	wiassaf	04/15/2024	sql	data-warehouse	reference	TSQL	>=aps-pdw-2016||=azure-sqldw-latest

sys.dm_pdw_dms_workers (Transact-SQL)

[!INCLUDE applies-to-version/asa-pdw]

Holds information about all workers completing DMS steps.

Note

[!INCLUDE synapse-analytics-od-unsupported-syntax]

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.
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.
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.
distribution_id	Int	Distribution that the worker is running on, if any.	See distribution_id in sys.pdw_distributions.
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.	[!INCLUDE ssInfoNA]
bytes_per_sec	bigint	Read or write throughput in the last second.	Greater than or equal to 0. NULL if the query was canceled 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 canceled 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 canceled 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.
end_time	datetime	Time at which execution ended, failed, or was canceled.	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 canceled 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.
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 the Metadata section in the Capacity limits topic.

Related content

• SQL and Parallel Data Warehouse Dynamic Management Views