Re: INSERT performance problems

All of these have been done, except for LRU_MIN and LRU_MAX, and CKPTINTVL. I'm reluctant to set those as such, because this is normally a heavy OLTP system (not a warehouse). I just have this one exception where a nightly job needs to do a large "posting." Is there any way to change these parameters dynamically, without taking the engine off-line? RG <rag4@mead.com> wrote in message news:37080F78.1D2E@mead.com... > Ok here are some suggestions straight from the Performance Tuning manual > on speeding up index builds. > 1. Use PDQ > 2. Allocate multiple temporary spaces on multiple disks...DBSPACETEMP > 3. Maximize SHMVIRTSIZE up to 75% of physical memory. > 4. Maximize BUFFERS > 5. Set LRUs = 4 * NUMCPUVPS. > 6. LRU_MAX_DIRTY = 80 and LRU_MIN_DIRTY = 70. This minimizes disk io > 7. CKPTINTVL = 3000. Again this helps minimize disk io. > > Again these are just suggestions.....and only for index builds, not > normal operations. >