system-statistical-functions-transact-sql.md

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