packet-errors-transact-sql.md

title	@@PACKET_ERRORS (Transact-SQL)
description	@@PACKET_ERRORS (Transact-SQL)
author	VanMSFT
ms.author	vanto
ms.date	09/18/2017
ms.service	sql
ms.subservice	t-sql
ms.topic	reference
f1_keywords	@@PACKET_ERRORS @@PACKET_ERRORS_TSQL
helpviewer_keywords	@@PACKET_ERRORS function number of packet errors packets [SQL Server], errors networking [SQL Server], packet errors connections [SQL Server], packets
dev_langs	TSQL

@@PACKET_ERRORS (Transact-SQL)

[!INCLUDE SQL Server Azure SQL Managed Instance]

Returns the number of network packet errors that have occurred on [!INCLUDEssNoVersion] connections since [!INCLUDEssNoVersion] was last started.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

@@PACKET_ERRORS  

Return Types

integer

Remarks

To display a report containing several [!INCLUDEssNoVersion] statistics, including packet errors, run sp_monitor.

Examples

The following example shows using @@PACKET_ERRORS.

SELECT @@PACKET_ERRORS AS 'Packet Errors';  

Here is a sample result set.

Packet Errors  
-------------  
0  

See Also

@@PACK_RECEIVED (Transact-SQL)
@@PACK_SENT (Transact-SQL)
sp_monitor (Transact-SQL)
System Statistical Functions (Transact-SQL)