SQL Server Probe SERVER_I/O calculation

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

How the SQLServer probe calculation the  SERVER_I/O ?

Environment

UIM 23.4

SqlServer 5.61

Resolution

SQLServer monitors percentage of I/O busy for sqlserver instance.

The below formula is for how calculating I/O busy percentage.

io_busy_pct = (io_busy*(timeticks/1000.0)/1000)*100 / time;