Skip to content

Latest commit

 

History

History
47 lines (41 loc) · 2.25 KB

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

File metadata and controls

47 lines (41 loc) · 2.25 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs monikerRange
sys.dm_exec_compute_node_errors (Transact-SQL)
sys.dm_exec_compute_node_errors (Transact-SQL)
rwestMSFT
randolphwest
11/04/2019
sql
system-objects
reference
SYS.DM_EXEC_COMPUTE_NODE_ERRORS_TSQL
DM_EXEC_COMPUTE_NODE_ERRORS
DM_EXEC_COMPUTE_NODE_ERRORS_TSQL
PolyBase
PolyBase, views
dm_exec_compute_node_errors
sys.dm_exec_compute_node_errors management view
TSQL
>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current

sys.dm_exec_compute_node_errors (Transact-SQL)

[!INCLUDE sqlserver2016-asdbmi]

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)