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.
Related content
Povratne informacije
https://aka.ms/ContentUserFeedback.
Kmalu na voljo: V letu 2024 bomo ukinili storitev Težave v storitvi GitHub kot mehanizem za povratne informacije za vsebino in jo zamenjali z novim sistemom za povratne informacije. Za več informacij si oglejte:Pošlji in prikaži povratne informacije za