Re: Checkpoints taking to long!!

>Hi > >I've run into a problem with the checkpoints on my production system - >they used to be all around 0 seconds long with the occasional 3 second >checkpoint - now they have increased to more like 10-15 seconds average >with a top of 20 seconds. We are running 730UC5 on a Sequent Box with 8 >CPU dedicated to the database and 40 gig of mirrored space. > >Below are the settings in my onconfig file - I have decreased the >max_dirty and min_dirty to see if it makes any difference, it didn't. Did you drop MIN_DIRTY to 1 and MAX_DIRTY to 2? Setting them that low should help a bit. >Should I increase the number of LRU's and decrease the size of the >logs?. Any ideas would be more than welcome. It might help to increase the number of LRUs, you'll just have to try it. How often are checkpoints occurring? Every 5 minutes or more frequently? ># Shared Memory Parameters > >LOCKS 3000000 # Maximum number of locks >BUFFERS 60000 # Maximum number of shared buffers >NUMAIOVPS # Number of IO vps >PHYSBUFF 32 # Physical log buffer size (Kbytes) >LOGBUFF 32 # Logical log buffer size (Kbytes)>LOGSMAX 40 # Maximum number of logical log files >CLEANERS 8 # Number of buffer cleaner processes >SHMBASE 0x10000000 # Shared memory base address >SHMVIRTSIZE 144000 # initial virtual shared memorysegment > >size >SHMADD 16000 # Size of new shared memory segments >(Kbytes) >SHMTOTAL 0 # Total shared memory (Kbytes). >0=>unlimited >CKPTINTVL 300 # Check point interval (in sec) >LRUS 16 # Number of LRU queues >LRU_MAX_DIRTY 40 # LRU percent dirty begin cleaninglimit > >LRU_MIN_DIRTY 35 # LRU percent dirty end cleaning limit >LTXHWM 50 # Long transaction high water mark>percentage >LTXEHWM 60 # Long transaction high water mark >(exclusive) >TXTIMEOUT 0x12c # Transaction timeout (in sec) >STACKSIZE 32 # Stack size (Kbytes)> > >thanks Bridget > > > > Get Your Private, Free Email at http://www.hotmail.com