sys.dm_pdw_os_threads (Transact-SQL)

APPLIES TO: noSQL Server noAzure SQL Database yesAzure SQL Data Warehouse yesParallel Data Warehouse

Column Name Data Type Description Range
pdw_node_id int The ID of the affected node.

pdw_node_id and thread_id form the key for this view.
See node_id in sys.dm_pdw_nodes (Transact-SQL).
thread_id int pdw_node_id and thread_id form the key for this view.
process_id int
name nvarchar(255)
priority int
start_time datetime
state nvarchar(32)
wait_reason nvarchar(32)
total_processor_elapsed_time bigint Total kernel time used by the thread.
total_user_elapsed_time bigint Total user time used by the thread

See Also

SQL Data Warehouse and Parallel Data Warehouse Dynamic Management Views (Transact-SQL)