Performance is getting worst after turn on the LRUAGE
Posted in 2004
Hi all, Due to the Bug 121515 where the LRU Queues get clogged with index pages, I have used the LRUAGE=1. Having the LRUAGE enabled, the buffer pool now being filled up by other pages (neither data pages nor index pages), and the performance is seems getting worst. Instead of being filled with high priority pages, the buffer pool predominantly contains MED_LOW pages. I was expecting to see a more even spread between MED_LOW and MED_HIGH pages. Disable the LRUAGE is not an option for me too as the buffer pool is filled up by the index pages which is also bring a performance problem to me. Is there anyone experience this problem? What can I do now? Before the change (without LRUAGE) ---------------------------------- Percentages: Data 12.16 Btree 86.52 Other 1.32 After the change (with LRUAGE=1) -------------------------------- Percentages: Data 20.29 Btree 29.90 Other 49.80 Thanks & regards, Miyaki __________________________________ Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time. http://taxes.yahoo.com/filing.html