@@IO_BUSY (T-SQL)

Returns the time in milliseconds (based on the resolution of the system timer) that Microsoft® SQL Server™ has spent doing input and output operations since it was last started.

Syntax

@@IO_BUSY

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 has spent performing input/output operations between start time and the current time.

SELECT @@IO_BUSY AS 'IO ms', GETDATE() AS 'As of'

  

Here is the result set:

IO ms                As of

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

31                   1998-04-18  16:49:49.650

  

See Also
@@CPU_BUSY System Statistical Functions
sp_monitor  

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.