sys.dm_exec_external_work (Transact-SQL)
SQL Server
Azure SQL Database
Azure Synapse Analytics (SQL DW)
Parallel Data Warehouse
Returns information about the workload per worker, on each compute node.
Query sys.dm_exec_external_work to identify the work spun up to communicate with the external data source (e.g. Hadoop or external SQL Server).
Column Name | Data Type | Description | Range |
---|---|---|---|
execution_id | nvarchar(32) |
Unique identifier for associated PolyBase query. | See request_ID in sys.dm_exec_requests (Transact-SQL). |
step_index | int |
The request this worker is performing. | See step_index in sys.dm_exec_requests (Transact-SQL). |
dms_step_index | int |
Step in the DMS plan that this worker is executing. | See sys.dm_exec_dms_workers (Transact-SQL). |
compute_node_id | int |
The node the worker is running on. | See sys.dm_exec_compute_nodes (Transact-SQL). |
type | nvarchar(60) |
The type of external work. | 'File Split' |
work_id | int |
ID of the actual split. | Greater than or equal to 0. |
input_name | nvarchar(4000) |
Name of the input to be read | File name when using Hadoop. |
read_location | bigint |
Offset or read location. | Offset of the file to read. |
bytes_processed | bigint |
Total bytes allocated for processing data by this worker. This may not necessarily represent the total data being returned by the query | Greater than or equal to 0. |
length | bigint |
Length of the split or HDFS block in case of Hadoop | User-definable. The default is 64M |
status | nvarchar(32) |
Status of the worker | Pending, Processing, Done, Failed, Aborted |
start_time | datetime |
Beginning of the work | |
end_time | datetime |
End of the work | |
total_elapsed_time | int |
Total time in milliseconds | |
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)
Feedback
Loading feedback...