Re: Tunning.

Bashar Chalabi wrote: > >For OLTP, try decreasing both of these. Try 2 and 1 or 2 and 0. > > Why? > To reduce checkpoint time. > The only reason I can think of is to reduce checkpoint time, but surely > there must be dramatic performance implications (of the negative kind). Not really. We use 8 and 4, 6 and 3 and have tested with 3 and 1. Checkpoints block the engine so nothing can proceed during a checkpoint. At least LRU writes are background so useful work can proceed. This gives OLTP systems a better "responsiveness". With low values for LRU cleanly checkpoints may take only a few seconds. The checkpoint writes are more efficient than LRU writes but that doesn't mean the engine dies as a result of LRU writes. Dominic -- Dominic Binks/Systems Engineer/Logica-Aldiscon 400 Park Avenue/Aztec West/Bristol/BS32 4TR/United Kingdom Tel: +44 1454 614455/Fax: +44 1454 620527/Mobile: +44 498 693964 E-mail: dominic.binks@aethos.co.uk