Post reply

script to check if indexes for a database sql server 2008 developer edition is highly fragemented rebuild otherwise reorganize

  • February 5, 2012 at 3:22 pm

    #251026

    Is there a script to check if the index if highly fragmented rebuild otherwise reorganize to run it for all indexes in a database or specific list of indexes

    I am using the developer edition so I was not able to rebuild online

    So I will take my web site and try to do it offline

    I do not have enough disk space

  • February 5, 2012 at 5:56 pm

    #1442870

    Developer edition can do online rebuilds, but they take even more space than offline rebuilds do.

    Scripts, certainly.

    http://sqlfool.com/2011/06/index-defrag-script-v4-1/

    or

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

    p.s. I hope I misunderstood you and you are not using developer edition for a production website...

    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

  • February 7, 2012 at 2:47 am

    #1443605

    Ola Hallengren has a really good solution find it here: - http://ola.hallengren.com/. However, as I too have found, disk space for Logs is an issue you need to resolve for these processes to work

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

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