sys.dm_exec_external_work (Transact-SQL)

APPLIES TO: yesSQL Server (starting with 2016) noAzure SQL Database yesAzure SQL Data Warehouse yesParallel 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 processed by this worker. 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

See Also

PolyBase troubleshooting with dynamic management views
Dynamic Management Views and Functions (Transact-SQL)
Database Related Dynamic Management Views (Transact-SQL)