Re: Buffwaits Ratio and Buffer Turnovers
In article <Mnj66.14312$nu5.119852@NewsReader>, "Earle A Long" <earle@btclick.com> wrote: > Thanks William, > > Okay the output from the program I've written to calculate the ratios you > mentioned looks like this :- > > Days, 1 Hours, 28 Minutes, 45 Seconds > dskreads=5128253 pagreads=5324645 bufreads= 369010470 %read > cached=98.61 > dskwrits=230342 pagwrits=465901 bufwrits=3934033 %writ > cached=94.14 > bufwaits=589924 BR=6.37 BT=24.77 BTR=16.75 BTF mins=3.55 BTF > secs=214.94 > Days, 1 Hours, 28 Minutes, 55 Seconds > dskreads=5130102 pagreads=5326667 bufreads= 369264488 %read > cached=98.61 > dskwrits=230709 pagwrits=466752 bufwrits=3937367 %writ > cached=94.14 > bufwaits=591725 BR=6.39 BT=24.79 BTR=16.73 BTF mins=3.55 BTF > secs=215.21 > Days, 1 Hours, 29 Minutes, 5 Seconds > dskreads=5132301 pagreads=5329201 bufreads= 369906361 %read > cached=98.61 > dskwrits=231024 pagwrits=467405 bufwrits=3941011 %writ > cached=94.14 > bufwaits=593553 BR=6.40 BT=24.81 BTR=16.71 BTF mins=3.59 BTF > secs=215.47 > Days, 1 Hours, 29 Minutes, 15 Seconds > dskreads=5133962 pagreads=5331087 bufreads= 370910522 %read > cached=98.62 > dskwrits=231381 pagwrits=468027 bufwrits=3943944 %writ > cached=94.13 > bufwaits=595340 BR=6.42 BT=24.82 BTR=16.68 BTF mins=3.59 BTF > secs=215.77 > Days, 1 Hours, 29 Minutes, 25 Seconds > dskreads=5135861 pagreads=5333300 bufreads= 371768310 %read > cached=98.62 > dskwrits=231776 pagwrits=468754 bufwrits=3961766 %writ > cached=94.15 > bufwaits=597463 BR=6.43 BT=24.87 BTR=16.69 BTF mins=3.58 BTF > secs=215.70 > > I wondered if you had any initial comments on the output or any other areas > we should be looking at to monitor performance. Our current onconfig.live is > below for information and comment should you so wish. > > Yours > > Earle A Long (Senior Informix DBA) > SINGLEPOINT LIMITED <SNIP> > LBU_PRESERVE 0 # Preserve last log for log backup <SNIP> I would probably set LBU_PRESERVE to 1. You might need to add another logical log to your system before you make this chnage because this causes the long transaction threshhold to take one less log file into consideration. If you have questions which are not addressed in the manuals feel free to ask more. Hope this helps, Will Sent via Deja.com http://www.deja.com/
Thanks Will, We don't use Transaction Logging at the moment and all logs are zapped when full. Yours -- Earle A Long (Senior Informix DBA) SINGLEPOINT UK LTD "William Rice" <ricew@operamail.com> wrote in message news:93cl2f$keo$1@nnrp1.deja.com... > In article <Mnj66.14312$nu5.119852@NewsReader>, > "Earle A Long" <earle@btclick.com> wrote: > > Thanks William, > > > > Okay the output from the program I've written to calculate the ratios > you > > mentioned looks like this :- > > > > Days, 1 Hours, 28 Minutes, 45 Seconds > > dskreads=5128253 pagreads=5324645 bufreads= 369010470 %read > > cached=98.61 > > dskwrits=230342 pagwrits=465901 bufwrits=3934033 %writ > > cached=94.14 > > bufwaits=589924 BR=6.37 BT=24.77 BTR=16.75 BTF mins=3.55 BTF > > secs=214.94 > > Days, 1 Hours, 28 Minutes, 55 Seconds > > dskreads=5130102 pagreads=5326667 bufreads= 369264488 %read > > cached=98.61 > > dskwrits=230709 pagwrits=466752 bufwrits=3937367 %writ > > cached=94.14 > > bufwaits=591725 BR=6.39 BT=24.79 BTR=16.73 BTF mins=3.55 BTF > > secs=215.21 > > Days, 1 Hours, 29 Minutes, 5 Seconds > > dskreads=5132301 pagreads=5329201 bufreads= 369906361 %read > > cached=98.61 > > dskwrits=231024 pagwrits=467405 bufwrits=3941011 %writ > > cached=94.14 > > bufwaits=593553 BR=6.40 BT=24.81 BTR=16.71 BTF mins=3.59 BTF > > secs=215.47 > > Days, 1 Hours, 29 Minutes, 15 Seconds > > dskreads=5133962 pagreads=5331087 bufreads= 370910522 %read > > cached=98.62 > > dskwrits=231381 pagwrits=468027 bufwrits=3943944 %writ > > cached=94.13 > > bufwaits=595340 BR=6.42 BT=24.82 BTR=16.68 BTF mins=3.59 BTF > > secs=215.77 > > Days, 1 Hours, 29 Minutes, 25 Seconds > > dskreads=5135861 pagreads=5333300 bufreads= 371768310 %read > > cached=98.62 > > dskwrits=231776 pagwrits=468754 bufwrits=3961766 %writ > > cached=94.15 > > bufwaits=597463 BR=6.43 BT=24.87 BTR=16.69 BTF mins=3.58 BTF > > secs=215.70 > > > > I wondered if you had any initial comments on the output or any other > areas > > we should be looking at to monitor performance. Our current > onconfig.live is > > below for information and comment should you so wish. > > > > Yours > > > > Earle A Long (Senior Informix DBA) > > SINGLEPOINT LIMITED > > <SNIP> > > LBU_PRESERVE 0 # Preserve last log for log backup > <SNIP> > > I would probably set LBU_PRESERVE to 1. You might need to add another > logical log to your system before you make this chnage because this > causes the long transaction threshhold to take one less log file into > consideration. If you have questions which are not addressed in the > manuals feel free to ask more. > > Hope this helps, > Will > > > > Sent via Deja.com > http://www.deja.com/