Re: Buffwaits Ratio and Buffer Turnovers

SELECT DATETIME(1970-01-01 00:00:00) YEAR TO SECOND + sh_pfclrtime UNITS SECOND profile_cleared FROM sysshmvals Will P.S. this is something I got from this newsgroup, and as much as I wish I could, I can claim absolutely no credit for coming up with this... In article <3s156.8979$nu5.86433@NewsReader>, "Earle A Long" <earle@btclick.com> wrote: > Having now written a monitoring program for the ratios mentioned in Art's > earlier emails we are currently running at a BR of 2.81. Any comments ?? > > Regarding the Buffer Turnovers I've got as far as the BT calculation but > nowhere can I find the time stats were last zeroed. Is this saved anywhere > if so where ?? > > Buffwaits Ratio > BR=buffwaits*100/(pagreads+bufwrits) > > Buffer Turnovers (BT) = (pagreads + bufwrits) / BUFFERS > BTR = BT / (#hours since stats were last zero'd out (ie onstat -z)) > BTF = (#minutes or seconds since stats zero'd) / BT > > -- > Earle A Long (Senior Informix DBA) > SINGLEPOINT UK LTD > > Sent via Deja.com http://www.deja.com/