system-statistical-functions-transact-sql.md

title	System Statistical Functions (Transact-SQL)
description	System Statistical Functions (Transact-SQL)
author	MikeRayMSFT
ms.author	mikeray
ms.date	03/15/2017
ms.service	sql
ms.subservice	t-sql
ms.topic	reference
helpviewer_keywords	statistical functions [SQL Server] system statistical functions [SQL Server] functions [SQL Server], statistical
dev_langs	TSQL

System Statistical Functions (Transact-SQL)

[!INCLUDE SQL Server Azure SQL Managed Instance]

The following scalar functions return statistical information about the system:

:::row::: :::column::: @@CONNECTIONS :::column-end::: :::column::: @@PACK_RECEIVED :::column-end::: :::row-end:::
:::row::: :::column::: @@CPU_BUSY :::column-end::: :::column::: @@PACK_SENT :::column-end::: :::row-end:::
:::row::: :::column::: fn_virtualfilestats :::column-end::: :::column::: @@TIMETICKS :::column-end::: :::row-end:::
:::row::: :::column::: @@IDLE :::column-end::: :::column::: @@TOTAL_ERRORS :::column-end::: :::row-end:::
:::row::: :::column::: @@IO_BUSY :::column-end::: :::column::: @@TOTAL_READ :::column-end::: :::row-end:::
:::row::: :::column::: @@PACKET_ERRORS :::column-end::: :::column::: @@TOTAL_WRITE :::column-end::: :::row-end:::

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)