Post reply

create alert for rebuild index job

  • June 20, 2014 at 9:42 am

    #1723642

    Just a head's up... it's very possible that the extra 1TB isn't going to be enough if you do the rebuild while in the FULL recovery mode. It'll create a replacement index in the database the index is in before it drops the old one (requires an extra 500GB if it's a clustered index) and it will be a fully logged exercise meaning the log file will most likely exceed 500GB of usage.

    Does the table need to be online and available during this rebuild?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • June 23, 2014 at 2:46 am

    #1723930

    Hi Jeff,

    Thanks for the reply, our DB is in simple recovery mode. The complete task took 5 hours to complete on Saturday. Quite happy that everything went as expected.

    The table had a clustered index but we choose not to maintain its index because its fragmentation % was below 5%. So we ended up rebuilding 10 non clustered index on this table.

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

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