Sunday, 12 April 2009

Log Growth despite db being in simple mode

My database is in Simple mode but the log won't stop growing!

On the box I am seeing this on, the system cannot keep up. Checkpoint conditions (to control the log) are simply not happening fast enough. After some reading, I've found this is because it is a high volume import system. The constant importing means the sql is not issuing a checkpoint to control log size :(

Why is my log autogrowing? >

Manually issuing a checkpoint >

No comments: