All Forums Database
Moutusi 38 posts Joined 03/13
22 Sep 2014
checking I/O skew

How can we check I/O skewed processing for a query?

Thanks, Moutusi
gryback 271 posts Joined 12/08
22 Sep 2014

You can check I/O skew in Viewpoint query portlets, Query Monitor for points in time and Query Spotlight over durations of time.

Moutusi 38 posts Joined 03/13
22 Sep 2014

Is there any way if we can check it using DBC.DBQLogTbl ?

Thanks,
Moutusi

VBurmist 96 posts Joined 12/09
22 Sep 2014

Hi Moutusi,
there are columns for maximum I/O and average I/O to get the I/O skew:

max = MaxAMPIO

avg = TotalIOCount / nullifzero( NumOfActiveAMPs )

 

skewfactor is  (100 - (avg/max*100))

 

Same for CPU.

 

Regards,

Vlad.

You must sign in to leave a comment.