Skip to content

pack-sent-transact-sql.md

Latest commit

 

History

History
62 lines (49 loc) · 1.85 KB

pack-sent-transact-sql.md

File metadata and controls

62 lines (49 loc) · 1.85 KB
title @@PACK_SENT (Transact-SQL)
description @@PACK_SENT (Transact-SQL)
author VanMSFT
ms.author vanto
ms.date 09/18/2017
ms.service sql
ms.subservice t-sql
ms.topic reference
f1_keywords
@@PACK_SENT
@@PACK_SENT_TSQL
helpviewer_keywords
number of output packets written
@@PACK_SENT function
packets [SQL Server], output
networking [SQL Server], output packets
connections [SQL Server], packets
output packets written to network [SQL Server]
dev_langs
TSQL

@@PACK_SENT (Transact-SQL)

[!INCLUDE SQL Server Azure SQL Managed Instance]

Returns the number of output packets written to 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_SENT

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_SENT.

SELECT @@PACK_SENT AS 'Pack Sent';

Here is a sample result set.

Pack Sent  
-----------  
291

See Also

@@PACK_RECEIVED (Transact-SQL)
sp_monitor (Transact-SQL)
System Statistical Functions (Transact-SQL)