Please or Register to create posts and topics.

Dashboard Instance - IO stall Read per second

#1 · May 9, 2018, 16 h 20 min

Hello Gregory,

First, thank you for your job, Kankuru is a great tool for monitoring SQL.

I download it 2 weeks ago and it help me a lot.

In the Instance Dashboard, 2 metrics seems have a wrong name :

IO Stall read per second and IO Stall Write per second

=> It seems to me its not "per second" but "in milliseconds".

no?

Anyway, thank you again for this great tool and see you soon.

Casey.

#2 · May 10, 2018, 14 h 19 min

Hi Casey,

First, thank you for your message. It's always a pleasure to know new users 🙂

You're right, the label is a bit confusing.

To collect data, I'm using the method GetDashboardInstance from KMO. I get io stall data from sys.dm_io_virtual_file_stats.

So you're right, I use the column io_stall_write_ms : Total time, in milliseconds, that users waited for writes to be completed on the file.

But I collect the data, I wait for 1 second and I recollect the data. Then I can calculate the difference between the 2 values.

So this value could be called : Total time, in milliseconds, during this second, that users waited for writes to be completed on the file 🙂

I hope you understood my ugly English and my explanations 🙂

#3 · May 10, 2018, 21 h 06 min

ok I understood.

Thank you for this explanation and don't worry for your English, between French we understand each other ;).

Forum