system-statistical-functions-transact-sql.md

title	System Statistical Functions (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/15/2017
ms.prod	sql
ms.prod_service	sql-database
ms.service
ms.component	t-sql|functions
ms.reviewer
ms.suite	sql
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
dev_langs	TSQL
helpviewer_keywords	statistical functions [SQL Server] system statistical functions [SQL Server] functions [SQL Server], statistical
ms.assetid	45828c67-1b9a-4653-bb24-86246084d8ba
caps.latest.revision	24
author	edmacauley
ms.author	edmaca
manager	craigg
ms.workload	On Demand

System Statistical Functions (Transact-SQL)

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

The following scalar functions return statistical information about the system:

@@CONNECTIONS	@@PACK_RECEIVED
@@CPU_BUSY	@@PACK_SENT
fn_virtualfilestats	@@TIMETICKS
@@IDLE	@@TOTAL_ERRORS
@@IO_BUSY	@@TOTAL_READ
@@PACKET_ERRORS	@@TOTAL_WRITE

All system statistical functions are nondeterministic. This means these functions do not always return the same results every time they are called, even with the same set of input values. For more information about function determinism, see Deterministic and Nondeterministic Functions.

See Also

Built-in Functions (Transact-SQL)