Skip to content

Latest commit

 

History

History
50 lines (44 loc) · 2.45 KB

File metadata and controls

50 lines (44 loc) · 2.45 KB
title sys.dm_exec_compute_node_errors (Transact-SQL) | Microsoft Docs
ms.custom
ms.date 11/04/2019
ms.prod sql
ms.prod_service database-engine, sql-data-warehouse, pdw
ms.reviewer
ms.technology system-objects
ms.topic language-reference
f1_keywords
SYS.DM_EXEC_COMPUTE_NODE_ERRORS_TSQL
DM_EXEC_COMPUTE_NODE_ERRORS
DM_EXEC_COMPUTE_NODE_ERRORS_TSQL
dev_langs
TSQL
helpviewer_keywords
PolyBase
PolyBase, views
dm_exec_compute_node_errors
sys.dm_exec_compute_node_errors management view
ms.assetid 9a03c039-70e4-4974-95d8-d3fa45984ffb
author CarlRabeler
ms.author carlrab
monikerRange >=aps-pdw-2016||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

sys.dm_exec_compute_node_errors (Transact-SQL)

[!INCLUDE sqlserver2016-asdbmi-asa-pdw]

Returns errors that occur on PolyBase compute nodes.

Column Name Data Type Description Range
error_id nvarchar(36) Unique numeric id associated with the error . Unique across all query errors in the system
source nvarchar(255) Source thread or process description
type nvarchar(255) Type of error.
create_time datetime The time of the error occurrence
compute_node_id int Identifier of the specific compute node See compute_node_id of sys.dm_exec_compute_nodes (Transact-SQL)
rexecution_id nvarchar(36) Identifier of the PolyBase query, if any.
spid int Identifier of the SQL Server session
thread_id int Numeric identifier of the thread on which the error occurred.
details nvarchar(4000) Full description of the details of the error.
compute_pool_id int Unique identifier for the pool.

See Also

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