Post reply

Maintenance Plan rebuild Index online option

  • October 5, 2011 at 1:11 pm

    #259909

    Hi all,

    I'm just wondering that If I use online option while doing ReBuild Index under Maintenance plan, There will be any Performance issues using this option

    My DB size is 500GB (at this time job is completing in 2 hours) but time to time we have locking/blocking issues

    Please let me know, thanks

    Dave

  • October 5, 2011 at 1:38 pm

    #1390914

    You should not see any signifigant locks - please review the following Microsoft document, in particular the part on "ONLINE"

    http://msdn.microsoft.com/en-us/library/ms188388.aspx

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • October 5, 2011 at 2:52 pm

    #1390967

    Thanks Chris

    I just want an expert advise before doing this

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

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