News:

GinGly.com - Used by 85,000 Members - SMS Backed up 7,35,000 - Contacts Stored  28,850 !!

Main Menu

@@CPU_BUSY

Started by sukishan, Aug 18, 2009, 08:03 PM

Previous topic - Next topic

sukishan

@@CPU_BUSY
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
A good beginning makes a good ending

dhoni

the small program has given in this it has used sql server

this can mainly used program for this

this goves more information from this website