SQL @@PACK_RECEIVED

SQL @@PACK_RECEIVED Statistical Function will return the total number of received packets in the network since the last time the server started. The syntax of this @@PACK_RECEIVED is

@@ PACK_RECEIVED

SQL @@PACK_RECEIVED Example

It shows you the total number of packets received by this network in this Server.

SELECT @@PACK_RECEIVED AS [Total Packets Received]

Use the GETDATE() along with Pack_received function to see the total received packets until today.

SELECT @@PACK_RECEIVED AS [Total Packets Received],
	GETDATE() AS [As of Today]

@@PACK_RECEIVED Example 2

In this Server example, we use both the Pack receive, and pack sent functions, along with Today’s date

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