Skip to content

Latest commit

 

History

History
59 lines (46 loc) · 1.68 KB

pack-received-transact-sql.md

File metadata and controls

59 lines (46 loc) · 1.68 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs
@@PACK_RECEIVED (Transact-SQL)
@@PACK_RECEIVED (Transact-SQL)
VanMSFT
vanto
03/14/2017
sql
t-sql
reference
@@PACK_RECEIVED_TSQL
@@PACK_RECEIVED
@@PACK_RECEIVED function
number of packets read
packets [SQL Server], number read
TSQL

@@PACK_RECEIVED (Transact-SQL)

[!INCLUDE SQL Server Azure SQL Managed Instance]

Returns the number of input packets read from the network by [!INCLUDEssNoVersion] since it was last started.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

@@PACK_RECEIVED  

Return Types

integer

Remarks

To display a report containing several [!INCLUDEssNoVersion] statistics, including packets sent and received, run sp_monitor.

Examples

The following example shows the usage of @@PACK_RECEIVED.

SELECT @@PACK_RECEIVED AS 'Packets Received';   

Here is a sample result set.

Packets Received  
----------------  
128  

See Also

@@PACK_SENT
sp_monitor
System Statistical Functions