SQL @@PACK_SENT is a System Statistical Function, returns the total number of output packets written to the network since the last time the SQL server started. The syntax behind this @@PACK_SENT is
@@PACK_SENT
SQL @@PACK_SENT Example
The below code snippet shows 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
You can use the GETDATE() function along with the 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
@@PACK_SENT Example 2
In this @@PACK_SENT 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