Tutorial Gateway

SQL @@PACK_SENT

by

SQL @@PACK_SENT is a System Statistical Function, returns the total number of output packets written to the network since SQL server is last started.

The syntax behind this @@PACK_SENT is

@@PACK_SENT

SQL @@PACK_SENT Example

Below code snippet will show you the total number of packets sent to the network in this SQL Server.

-- SQL Server @@PACK_SENT Example
SELECT @@PACK_SENT AS [Total Packets Sent]

OUTPUT

SQL @@PACK_SENT Example 1

You can use GETDATE() function along with Pack_sent function to see the total packets sent until today.

-- SQL Server @@PACK_SENT Example
SELECT @@PACK_SENT AS [Total Packets Sent],
	GETDATE() AS [As of Today]

OUTPUT

SQL @@PACK_SENT Example 2

SQL @@PACK_SENT Example 2

In this example we are using both the Packet sent and Packet receive functions, along with Today’s date

-- SQL Server @@PACK_SENT Example
SELECT 	@@PACK_SENT AS [Total Packets Sent],
	@@PACK_RECEIVED AS [Total Packets Received],
	GETDATE() AS [As of Today]

OUTPUT

SQL @@PACK_SENT Example 3

Placed Under: SQL