Skip to content

pack-sent-transact-sql.md

Latest commit

 

History

History
65 lines (52 loc) · 2.01 KB

pack-sent-transact-sql.md

File metadata and controls

65 lines (52 loc) · 2.01 KB
title @@PACK_SENT (Transact-SQL) | Microsoft Docs
ms.custom
ms.date 09/18/2017
ms.prod sql
ms.prod_service sql-database
ms.reviewer
ms.technology t-sql
ms.topic language-reference
f1_keywords
@@PACK_SENT
@@PACK_SENT_TSQL
dev_langs
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]
ms.assetid 8a322162-24c9-48e9-bfa4-c060e4e11dba
author VanMSFT
ms.author vanto

@@PACK_SENT (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

Returns the number of output packets written to the network by [!INCLUDEssNoVersion] since it was last started.

Topic link icon 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)