Post reply

Reorganizing Indexes in 2008 R2

  • March 22, 2011 at 8:16 am

    #1301895

    I can be the first beta tester if you want :w00t:.

  • March 22, 2011 at 8:21 am

    #1301899

    Thanks Ninja. I'll be certain to share.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • March 23, 2011 at 3:23 am

    #1302335

    Patricia Johnson (3/22/2011)

    Hey Muthukkumaran,

    Your website link said to defrag indexes based on these conditions:

    1. Fragmentation >30 AND PAGES>1000 then rebuild

    2. Fragmentation between 15 to 30 AND PAGES>1000 then reorganize&updatestatistics

    3. If the above two conditions are false then update the statistics

    Do you have anything to help me identify when #1 is true, or when #2 is true.

    I would like to run this as a step in a job. If the condition for #1 is true, then run your index defrag sql or if #2 is true, then run a index reorg sql followed by an update statistics sql, or if #3 is true then just update the statistics. That would be really cool if there something out there that I could use.

    Thanks Muthukkumaran.

    Patti

    Thanks Patti now it's fixed.

    Definitely Michelle's script is good and its covers all the parts.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

Viewing 3 posts - 16 through 17 (of 17 total)

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