Re: Tunning.

From: "Bashar Chalabi" <bashar@ctl.com> > > >>LRU_MAX_DIRTY 60 # LRU percent dirty begin cleaning limit > >>LRU_MIN_DIRTY 50 # LRU percent dirty end cleaning limit> > > >For OLTP, try decreasing both of these. Try 2 and 1 or 2 and 0. > >Why? > >The only reason I can think of is to reduce checkpoint time, but surely >there must be dramatic performance implications (of the negative kind). I'm just going to find somewhere to hide while Art steams in... :-) ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com