Re: How do I check LRU contention - onstat -g spi ????

bothwellno@spam.duke.edu wrote: > Art S. Kagel & Family <kagel@erols.com> wrote: > : InfoJones wrote: > : [output SNIPPED] > > : To determine whether buffer contention or LRU contention is involved > : try to calculate your buffer turnover rate: > > : Buffer Turnovers = (dskreads + bufwrits) / BUFFERS Buffer Turnovers = (pagreads + bufwrits) / BUFFERS > > : BTR = (Buffer Turnover) / (time since last stats clearing) expressed > : as turnovers per unit time. > > Should one multiply BUFFERS by page size in the Buffer Turnovers calculation > or go with just the value of BUFFERS from the config file? Just use BUFFERS as the reported numbers on the onstat -p report are in pages not KB. BTW the first formula above should be using pagreads not dskreads, mia culpa. See corrected formula above. > > > : If you are turning over your buffer pool more often than a few times > : an hour you probably need more buffers. Add buffers and check again. > > : -- > : Art S. Kagel & Family > : kagel@erols.com > > -- > bothwellno@spam.duke.edu