SQL @@PACK_RECEIVED

SQL @@PACK_RECEIVED Statistical Function will return the total number of received packets in the network since the last time the SQL 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 SQL Server.

-- SQL Server @@PACK_RECEIVED Example
SELECT @@PACK_RECEIVED AS [Total Packets Received]
SQL @@PACK_RECEIVED Example 1

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

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

@@PACK_RECEIVED Example 2

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

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