Post reply

rebuild is failing

  • October 5, 2019 at 8:14 am

    #3686198

    Hi Experts,

    One of the HEAP table rebuild operation is failing in one of our dev env. Have some few questions, kindly help.

    >ALTER TABLE HeapTbl REBUILD;

    There is a HEAP table which has 88% fragmentation and it is around ~25GB. The table also contains LOB datatypes columns as well. When we try to rebuild the HEAP , it is throwing transaction log full error.

    Questions

    1. How much disk space (in .mdf or .ndf) is required for the rebuild operation to complete successfully?

    2. How much Tempdb space is required for the rebuild operation to complete successfully?

    3. How much Transaction log file space is required for rebuild operation to complete successfully?

    Thanks,

    Sam

  • October 6, 2019 at 9:10 am

    #3686311

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • October 8, 2019 at 6:34 pm

    #3687145

    When you are rebuilding a HEAP it also rebuilds all the NC indexes on your heap table as a side effect. You have to keep that in mind and plan for your T-Log size accordingly.

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

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