Post reply

Index Job (rebuild & Reorganize) and Log space used question

  • December 6, 2014 at 8:20 am

    #293147

    Hi there,

    I have a Index job (reorganize and rebuild) runs every week, it generates 20-30 GB (according to log shipping backup job) and I have 50 GB allocated for Log file.

    When the Index job runs DBCC sqlperf (logspace) shows 70+ % used even sometime goes 90+%. Am I missing something here?

  • December 7, 2014 at 7:17 pm

    #1763188

    Hi

    its normal that the log usage is high during index rebuild. you can try bulk logged recovery if you want to lower the transaction log usage during index rebuild, but please note that the transaction log backup size will still be large because it has to backup the data pages also after a bulk operation.

    JJ

  • December 8, 2014 at 8:43 am

    #1763293

    Thanks for your reply 🙂

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply