Re: Performance tuning 7.3 newbie questions

Gary Quiring wrote: > > We are running 7.3 IDS on SCO OpenServer 5.0.5. The checkpoints can be > fairly long at 34 seconds. The server is a Dell 6300 400mhz Xeon with 4 > chips and 4 gig of memory serving approx. 140 users. > We are going to move the Informix DB to a Sun box within 2 months, but I > would like to improve things if possible on the SCO server. > > What is the basic logic behind how you control checkpoints? More LRUS, more CLEANERS, lower LRU_MAX/MIN_DIRTY numbers, longer CKPTINTVL to reduce the impact of longish checkpoints, fewer buffers if other factors permit, faster disk farm (ie RAID10 instead of RAID5 or singleton drives), faster controllers, more controllers, more spindles, higher RPM drives. I'd max out LRUS/CLEANERS to 128, set the LRU_ parameters to 1/0, and increase CKPTINTVL to 600. Art S. Kagel