SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Explaining log growth for Simple recovery database


Explaining log growth for Simple recovery database

Author
Message
Maddave
Maddave
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1760 Visits: 1466
I thought I understood log growth, but a bit confused why the following is happening.

We use SQL Monitor and Ola's maintenance scripts on our 2012 instance. These are set to rebuild indexes when 30% fragmentation occurs.
Over the weekend the SQL Monitor database, set to Simple recovery, experienced the transaction log grow from 3 GB to 35 GB and it filled up the disk. This was due to the rebuild index operation from the maintenance scripts which rebuilt just 13 indexes before the disk became full.

Looking at these indexes, their total storage size is just over 1GB. I thought when a rebuild happens then the log would only grow to the size of the index as that is all that would need to be rolled back, so why did the log grow to 35 GB? Any why, on a simple recovery databases did the log not get reused, after the first few rebuild commands completed?

Any pointers would be good to understand this a bit better and to narrow down the reason..
Thanks.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search