Transaction Tuning

You can increase performance when using transactions.

• Locate Checkpoint and Transaction Log Files on Separate Physical Device

• Size Transactions Appropriately

• Use Durable Commits Appropriately

• Avoid Manual Checkpoints

• Turn Off Autocommit Mode

• Avoid Transaction Roll Back

• Avoid Large DELETE Statements

• Increase the Commit Buffer Cache Size