Re: BUFFERS setting
Posted in 1998
Topics: Performance & Tuning, Server Administration, Logging & Checkpoints
Steve, Don't forget that as you increase the number of buffers, there are more to clean at checkpoint time so your checkpoint duration will increase. You can counter-act this by tuning the LRU_MAX_DIRTY and LRU_MIN_DIRTY onconfig parameters. You can also add more LRU's to have less buffers per LRU but then also don't forget to increase your CLEANERS... HTH Scott Steve Romankiw wrote: > --------------702998A58126E25C8994BACE > Content-Type: text/plain; charset=us-ascii > Content-Transfer-Encoding: 7bit > > For a UNIX server that is a dedicated database server, if you have the > BUFFERS setting too high, is that a bad thing? > > -- > ----------------------------------------------------------------- > Steve Romankiw + > Executive Risk Inc. + > DBA + email: sromankiw@execrisk.com > 82 Hopmeadow Street + work: (860) 408-2474 > Simsbury,CT 06070 + fax: (860) 408-2139 > ----------------------------------------------------------------- > > --------------702998A58126E25C8994BACE > Content-Type: text/html; charset=us-ascii > Content-Transfer-Encoding: 7bit > > <HTML> > For a UNIX server that is a dedicated database server, if you have the > BUFFERS setting too high, is that a bad thing? > > <P>-- > <BR><TT>-----------------------------------------------------------------</TT> > <BR><TT>Steve Romankiw +</TT> > <BR><TT>Executive Risk Inc. +</TT> > <BR><TT>DBA > + email: sromankiw@execrisk.com</TT> > <BR><TT>82 Hopmeadow Street + work: > (860) 408-2474</TT> > <BR><TT>Simsbury,CT 06070 + fax: > (860) 408-2139</TT> > <BR><TT>-----------------------------------------------------------------</TT> > <BR><TT></TT> </HTML> > > --------------702998A58126E25C8994BACE-- -- Scott Hanson System Support Analyst mailto:shanson@gb.dhl.com aka:sm_hanson@hotmail.com