search cancel

Need additional clarification on a sqlserver metric (server_io)

book

Article ID: 187034

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

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 clarification...is  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?

Environment

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

Resolution

sqlserver probe checkpoint: server_io

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

Details:
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.

query:

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.
https://ca-broadcomcsm.wolkenservicedesk.com/wolken/esd/knowledgebase_list?articleId=39422

You may also find this url/discussion useful:
https://www.databasejournal.com/features/mssql/finding-the-source-of-your-sql-server-io.html

Attachments