Post reply

Questions on Index Rebuilding (not reorganize)

  • June 13, 2013 at 11:30 pm

    #1623958

    Hi All experts,

    One last question.

    Let's say there is a need to rebuild 50+ indexes (due to fragmentation).

    I did a check on the DB and the sum of all the indexes to be rebuild is 150GB.

    The largest index is about 20 GB size.

    Let's say my db recovery model is full and i doesn't do any transaction log backup during that time.

    Understand that the target database need free space of the largest size index for rebuild.

    But Does it really need 150 GB of transaction log size to do the rebuild?

    thanks

  • June 13, 2013 at 11:38 pm

    #1623959

    chewychewy (6/13/2013)

    But Does it really need 150 GB of transaction log size to do the rebuild?

    Probably more than 150. 200 or 250 to be safe.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 13, 2013 at 11:47 pm

    #1623961

    appreciate ur help!

    recently just for test purpose, i actually rebuild a db woth of 100 GB indexes.

    But only used up 16GB transaction log.

    guess i'l' do some additional testing.

    thanks!

  • June 13, 2013 at 11:52 pm

    #1623962

    chewychewy (6/13/2013)

    recently just for test purpose, i actually rebuild a db woth of 100 GB indexes.

    But only used up 16GB transaction log.

    The database was in simple or bulk-logged recovery model.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 16 through 18 (of 18 total)

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