RE: lchwaits, read aheads

AaaarrrrrHHHHHH ! That's what happens when you try to do work on the weekend and shows indications of being under the influence while providing assistance.... The correct formula is.... (1 + 2 + 3) - 4 = < 2% & > 0.5% of (1 + 2 + 3) 1) Add ixda-RA + idx-RA + da-RA (4398 + 29 + 27805 = 32232) 2) Subtract RA-pgsused from the result 32232 - 32188 = 44 = 0.14% of 32232 The result is less than 0.5%, so the advice of increasing the RA configuration at least was correct. Cheers, Tony. ---------- From: Rick Bernstein To: tony edwards Subject: RE: lchwaits, read aheads Date: Monday, 15 September 1997 09:12 Won't your formula always produce a negative number? I.E. Read-ahead pages used will be less than Read-ahead pages read. ==== ==== Perhaps the formula should read: (1 + 2 + 3) - 4 = < 2% & > 0.5% of 4 At 11:24 AM 9/14/97 +1200, you wrote: }The simple guide to tuning RA pages... } }4 - (3 + 2 + 1) = < 2% & > 0.5% of 4 } }The explanation.... }Add ixda-RA + idx-RA + da-RA (4398 + 29 + 27805 = 32232) }Subtract the result from RA-pgsused (32188 - 32232 = a negative number) } Since the result is a negative number you need to increase the RA }configuration. } }You want the result of the calculation to be between 0.5% and 2% of }RA-pgsused. If the result of the calculation is above 2% you need reduce }the RA configuration. } }Cheers, Tony. }#include <standard disclaimers> } ---------- }From: Manoj }To: 'informix-list@rmy.emory.edu' }Subject: lchwaits, read aheads }Date: Friday, 12 September 1997 23:27 } }All, } }Are there any guidelines for the below ? } }ixda-RA idx-RA da-RA RA-pgsused lchwaits }4398 29 27805 32188 55 } }Thanks, } } Manoj Schroff, } Two Way TV Ltd, UK } +44(0)181 996 8221 } manoj@mailhost.twowaytv.co.uk } http://www.twowaytv.co.uk } } } }