@@CPU_BUSY
SQL Server 2000
Returns the time in milliseconds (based on the resolution of the system timer) that the CPU has spent working 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
