sys-dm-pdw-os-threads-transact-sql.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	dev_langs	monikerRange
sys.dm_pdw_os_threads (Transact-SQL)	sys.dm_pdw_os_threads (Transact-SQL)	WilliamDAssafMSFT	wiassaf	03/07/2017	sql	data-warehouse	reference	TSQL	>=aps-pdw-2016||=azure-sqldw-latest

sys.dm_pdw_os_threads (Transact-SQL)

[!INCLUDEapplies-to-version/asa-pdw]

Note

[!INCLUDEsynapse-analytics-od-unsupported-syntax]

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

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