SQL @@PACKET_ERRORS Example 2

SQL @@PACKET_ERRORS

by

SQL @@PACKET_ERRORS Statistical Function returns the network packet errors that occurred on connection since the last time the SQL server started. The syntax behind this @@PACKET_ERRORS is

@@PACKET_ERRORS

SQL @@PACKET_ERRORS Example

The below code snippet will show you the total number of network packet errors that occurred in this SQL Server.

-- SQL Server @@PACKET_ERRORS Example
SELECT @@PACKET_ERRORS AS [Total Number of Packet Errors]
SQL @@PACKET_ERRORS Example 1

You can use the GETDATE() along with Packet_errors function to see the network errors until today.

-- SQL Server @@PACKET_ERRORS Example
SELECT @@PACKET_ERRORS AS [Total Number of Packet Errors],
	GETDATE() AS [As of Today]
SQL @@PACKET_ERRORS Example 2