Skip to content

sys-dm-exec-compute-node-status-transact-sql.md

Latest commit

 

History

History
60 lines (55 loc) · 3.08 KB

sys-dm-exec-compute-node-status-transact-sql.md

File metadata and controls

60 lines (55 loc) · 3.08 KB

title: "sys.dm_exec_compute_node_status (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "03/15/2017" ms.prod: "sql" ms.prod_service: "database-engine, sql-data-warehouse, pdw" ms.service: "" ms.component: "dmv's" ms.reviewer: "" ms.suite: "sql" ms.technology:

  • "database-engine" ms.tgt_pltfrm: "" ms.topic: "language-reference" f1_keywords:
  • "DM_EXEC_COMPUTE_NODE_STATUS_TSQL"
  • "DM_EXEC_COMPUTE_NODE_STATUS" dev_langs:
  • "TSQL" helpviewer_keywords:
  • "PolyBase,views"
  • "PolyBase"
  • "dm_exec_compute_node_status"
  • "sys.dm_exec_compute_node_status management view" ms.assetid: b606f91f-3a08-4a4f-bb57-32ae155b3738 caps.latest.revision: 7 author: "stevestein" ms.author: "sstein" manager: "craigg" ms.workload: "Inactive" monikerRange: ">= aps-pdw-2016 || = azure-sqldw-latest || >= sql-server-2016 || = sqlallproducts-allversions"

sys.dm_exec_compute_node_status (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2016-xxxx-asdw-pdw-md]

Holds additional information about the performance and status of all PolyBase nodes. Lists one row per node.

Column Name Data Type Description Range
compute_node_id int Unique numeric id associated with the node. Unique across scale-out cluster regardless of type.
process_id int
process_name nvarchar(255) Logical name of the node. Any string of appropriate length.
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
received_time datetime Last time a network package was sent by this node.
error_id nvarchar(36) Unique identifier of the last error that occurred on this node.

See Also

PolyBase troubleshooting with dynamic management views
Dynamic Management Views and Functions (Transact-SQL)
Database Related Dynamic Management Views (Transact-SQL)