sys-dm-pdw-node-status-transact-sql.md

title	sys.dm_pdw_node_status (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/07/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
dev_langs	TSQL
ms.assetid	8e263b65-81d0-49d0-8873-62ef424369d6
caps.latest.revision	7
author	barbkess
ms.author	barbkess
manager	jhubbard

sys.dm_pdw_node_status (Transact-SQL)

[!INCLUDEtsql-appliesto-xxxxxx-xxxx-xxxx-pdw_md]

Holds additional information (over sys.dm_pdw_nodes (Transact-SQL)) about the performance and status of all appliance nodes. It lists one row per node in the appliance.

Column Name	Data Type	Description	Range
pdw_node_id	int	Unique numeric id associated with the node. Key for this view.	Unique across the appliance, regardless of type.
process_id	int	[!INCLUDEssInfoNA]
process_name	nvarchar(255)	[!INCLUDEssInfoNA]
allocated_memory	bigint	Total allocated memory on this node.
available_memory	bigint	Total available memory on this node.
process_cpu_usage	bigint	Total process CPU usage, in ticks.
total_cpu_usage	bigint	Total CPU usage, in ticks.
thread_count	bigint	Total number of threads in use on this node.
handle_count	bigint	Total number of handles in use on this node.
total_elapsed_time	bigint	Total time elapsed since system start or restart.	Total time elapsed since system start or restart. If total_elapsed_time exceeds the maximum value for an integer (24.8 days in milliseconds), it will cause materialization failure due to overflow. The maximum value in milliseconds is equivalent to 24.8 days.
is_available	bit	Flag indicating whether this node is available.
sent_time	datetime	Last time a network package was sent by this node.
received_time	datetime	Last time a network package was received by this node.
error_id	nvarchar(36)	Unique identifier of the last error that occurred on this node.

See Also

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