@@IO_BUSY

Transact-SQL Reference

Transact-SQL Reference

@@IO_BUSY

Returns the time in milliseconds (based on the resolution of the system timer) that Microsoft® SQL Server™ has spent performing 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

sp_monitor

System Statistical Functions