sys.dm_exec_external_work (Transact-SQL)

APPLIES TO: yes SQL Server Azure SQL Database yes Azure Synapse Analytics (SQL DW) yes 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