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]
SQL @@PACK_RECEIVED Example 1

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

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 tutorial example, we use both the Pack receives and Pack sent functions, along with Today’s date. Please refer to the SQL @@PACK_SENT and SQL @@PACKET_ERRORS articles.

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