Post reply

Multiple Index Rebuild

  • November 23, 2012 at 7:06 am

    #271146

    Hi Experts,

    Production team have send a rebuild index script for 100 indexes ,i need to run this in staging and have to give result to them. All the 100 rebuild is online and my tempdb data drive free space is 1.3TB and log drive free space is 485Gb. Average size of each index is around 80GB

    I have said NO to run the script as it may cause tempdb to fill up. Am I wrong here ,Please advise

    Thanks in advance.

  • November 23, 2012 at 8:24 am

    #1561879

    Can anyone please reply?

  • November 23, 2012 at 8:30 am

    #1561880

    Can you have some patience? It's only been an hour, on a holiday weekend for the US.

    If the largest index is 80 GB, then the peak usage of TempDB won't even hit 300GB, much less 1300GB (as long as you don't plan on running all 100 rebuilds in a single translation).

    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 3 posts - 1 through 2 (of 2 total)

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