sys.dm_exec_external_work

Description

2016 (13.x) and later versions Returns information about the workload per worker, on each compute node. to identify the work spun up to communicate with the external data source (for example, Hadoop or MongoDB). sys.dm_exec_requests (Transact- sys.dm_exec_requests (Transact- sys.dm_exec_dms_workers (Transact-SQL) sys.dm_exec_compute_nodes (Transact-SQL) ‘File Split’ (for Hadoop and Azure storage)

Syntax

sys.dm_exec_external_work