sys.dm_pdw_dms_workers (Transact-SQL)
Applies to: 
Azure Synapse Analytics
Analytics Platform System (PDW)
Holds information about all workers completing DMS steps.
Note
This syntax is not supported by serverless SQL pool in Azure Synapse Analytics.
| 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. | Information not available. |
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.