ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Need additional clarification on a sqlserver metric (server_io)


Article ID: 187034


Updated On:


NIMSOFT PROBES DX Unified Infrastructure Management (Nimsoft / UIM)


Metric Name: server_io. This metric is defined in the guide as: "Monitors percentage of I/O busy for SQL Server instance in interval". Please provide more  this for SQL server or the VM OS? Also what exactly does this check display if OS  or SQL...ethernet adapter saturation value? Anything else?


Release : 8.51
Component : sqlserver
sqlserver v5.42-T3


sqlserver probe checkpoint: server_io

Monitors percentage of I/O busy for SQL Server instance in interval

Returns the 'time that SQL Server has spent performing input and output operations since SQL Server was last started.' The result is in CPU time increments ("ticks"), and is cumulative for all CPUs, so it may exceed the actual elapsed time.


select @@IO_BUSY io_busy, @@TIMETICKS timeticks, datediff(ss, '1970-01-01 00:00:00', getdate()) time

Example result:

Please note that if you don't find what you're looking for with a certain checkpoint/query, you can create your own custom checkpoint in the sqlserver probe.

You may also find this url/discussion useful: