News:

Latest Movie Updates : Cinebuzz.in
Latest Update on Rajini Movie  Enthiran / Endhiran - Rajini - The Robot

Main Menu

@@IDLE

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

Previous topic - Next topic

sukishan

@@IDLE
Returns the time in milliseconds (based on the resolution of the system timer) that Microsoft® SQL Server™ has been idle since last started.

Syntax
@@IDLE

Return Types
integer

Remarks
To display a report containing several SQL Server statistics, run sp_monitor.

Examples
This example shows the number of milliseconds SQL Server was idle between the start time and the current time.

SELECT @@IDLE AS 'Idle ms', GETDATE() AS 'As of'
Here is the result set:

Idle Ms              As of
-----------------    ---------------------------
277593               1998-04-18  16:41:07.160
A good beginning makes a good ending

pradeep prem

this sql server is mainly solve problem
with this easy calculation to solve it