Home Forums SQL Server 2008 SQL Server 2008 Administration Fragmentation size RE: Fragmentation size

  • December 26, 2012 at 1:34 pm

    #1571664

    zi (12/26/2012)

    - what if I have a huge database = 'Tables' , how to know that I need to re-organise or to re-build indexes

    Then you look at the fragmentation of the indexes and decide which to rebuild. I recommend you use something like Ola's scripts

    http://ola.hallengren.com/Versions.html

    -why when re-organise or re-build indexes make log file bigger.

    Because all modifications to the DB are logged and both index rebuilds and reorganise operations do a substantial amount of modifications

    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