estimate disk space for index rebuild operation

  • For a rebuild, you generally want to have enough free space to cover your largest index and then add some for breathing room.

    If you decide to do a reorg instead - the space requirement is less.

    In this case for a rebuild we would be looking at needing at least 240GB free to store a copy of the index as it is rebuilt. Then you also need log space to support the actual operation.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing post 1 (of 2 total)

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