Post reply

SQL SERVER index rebuild job fails periodically at update stats.

  • March 31, 2015 at 7:57 am

    #1787731

    qur7 (3/31/2015)

    When I will do retry, will it start the whole process again , or just starts form the failed index?

    With Regards,

    Ahmed

    It will retry the whole process, but have in count that the rebuilt indexes until the point are not taking part in the next immediate rebuild process.

    Igor Micev,My blog: www.igormicev.com

  • March 31, 2015 at 8:04 am

    #1787736

    I have modified the CommandExecute stored procedure of Ola so that it makes three tries in order to rebuild. I also set the deadlock priority to "LOW" but that is for the purposes of my environment.

    I also have put retry=1 for the job.

    You can try with this version of the procedure.

    Igor Micev,My blog: www.igormicev.com

Viewing 2 posts - 16 through 17 (of 17 total)

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