@@CPU_BUSY (T-SQL)

Returns the time in milliseconds (based on the resolution of the system timer) that the CPU has spent doing work since Microsoft® SQL Server™ was last started.

Syntax

@@CPU_BUSY

Return Types

integer

Remarks

To display a report containing several SQL Server statistics, including CPU activity, run sp_monitor.

Examples

This example shows SQL Server CPU activity as of the current date and time.

SELECT @@CPU_BUSY AS 'CPU ms', GETDATE() AS 'As of'

Here is the result set:

CPU ms               As of

-----------------    ---------------------------

20                   1998-04-18  14:43:08.180

See Also