0 out of 1 rated this helpful - Rate this topic

@@PACKET_ERRORS (Transact-SQL)

SQL Server 2012

Returns the number of network packet errors that have occurred on SQL Server connections since SQL Server was last started.


@@PACKET_ERRORS

integer

To display a report containing several SQL Server statistics, including packet errors, run sp_monitor.

The following example shows using @@PACKET_ERRORS.

SELECT @@PACKET_ERRORS AS 'Packet Errors'

Here is a sample result set.

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

@@PACK_RECEIVED (Transact-SQL)

@@PACK_SENT (Transact-SQL)

sp_monitor (Transact-SQL)

System Statistical Functions (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions