real IO bottlenecks

Real-time performance monitoring and troubleshooting

real IO bottlenecks

Veeam Logoby ivordillen » Mon Aug 06, 2012 2:28 pm

I recently got an issue with a heavily loaded SQL server where the KAVG/cmd and the GAVG/cmd got to high what means my storage box couldn't follow, I got latency,...

I was a little bit dissapointed that I didn't get an error in the monitor because that are the real benefits for system admins imo

Ivor
ivordillen
Enthusiast
 
Posts: 61
Liked: never
Joined: Thu Nov 03, 2011 2:55 pm
Full Name: Ivor Dillen

Re: real IO bottlenecks

Veeam Logoby Vitaliy S. » Mon Aug 06, 2012 3:33 pm

Hi Ivor,

Could you please tell what type of storage do you have? How is it connected to your host? Did you see high latency on your storage disk?

Thanks!
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: real IO bottlenecks

Veeam Logoby ivordillen » Mon Aug 06, 2012 7:51 pm

Vitaliy

I have a HP P6000 connected via FC. We have a few times a day +3000 IOPS and then the latency of that disk goes to 30-40 for the duration 5-15min.

Ivor
ivordillen
Enthusiast
 
Posts: 61
Liked: never
Joined: Thu Nov 03, 2011 2:55 pm
Full Name: Ivor Dillen

Re: real IO bottlenecks

Veeam Logoby Vitaliy S. » Tue Aug 07, 2012 2:11 pm 1 person likes this post

Thanks for clarifications. Currently we do not collect VMkernel read/write latency metrics, but I believe it shouldn't be a problem to add these counters in our next updates.
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: real IO bottlenecks

Veeam Logoby ivordillen » Tue Aug 07, 2012 2:36 pm

I think that is a munst because at this level you are a real asset. At this level you find the real problems relating to queu depth or IO size,... A lot of info to put some intelligence!
ivordillen
Enthusiast
 
Posts: 61
Liked: never
Joined: Thu Nov 03, 2011 2:55 pm
Full Name: Ivor Dillen


Return to Monitoring



Who is online

Users browsing this forum: No registered users and 3 guests