Re: Config for new live system

Besides LRU, i would look at OPTCOMPIND 2 # To hint the optimizeris this oltp?? then set it to 0 !! PHYSFILE 102294 # Physical log file size (Kbytes) i would make this bigger specially when i see how much buffers are configured. (maybe to the max which is afaik in 7.3 2 GB.) PHYSBUFF 32 # Physical log buffer size (Kbytes)would make this bigger say 128 or 256.... LOGBUFF 32 # Logical log buffer size (Kbytes)would make this bigger say 128 or 256.... RESIDENT 0 # Forced residency flag (Yes = 1, No = 0) would set this to 1 or maybe -1 or -2 if the memory the db is using should not be swapped out. CKPTINTVL 300 # Check point interval (in sec) i would set this to 15 min's or 30... See you Superboer. Bill Dare <dareb@jevic.com> wrote in message news:<cierbg$2nu$1@news.xmission.com>... > Ditto on Keith's comments about the LRU config. If you are going to > configure that many buffers I think you need a lot more LRUs to manage them > and more CLEANERS to flush them. And the MIN and MAX dirty are way too > high. You could be looking at some very long checkpoints and high bufwaits > if this is a busy system. Try a google search on "LRU configuration Kagel" > for some interesting reading. > > Regards, > Bill > >