Index Defrag Script Updates – Beta Testers Needed

Update: Wow! I’ve received a ton of responses to my request for beta testers. Thank you all! The SQL Community is really amazing. I’ll hopefully have the new version online in just a few days. :)

Over the last few months, I’ve received many great comments and suggestions regarding my Index Defrag Script v3.0. I’ve just recently had time to implement most of these suggestions, plus some other things that I thought would be useful. :)

Here’s some of what you can look forward to shortly:

  • Probably the single most requested feature, the new version of the script allows you to set a time limit for index defrags.
  • There’s now a static table for managing the status of index defrags. This way, when your time limit is reached, you can pick up where you left off the next day, without the need to rescan indexes.
  • There’s now an option to prioritize defrags by range scan counts, fragmentation level, or page counts.
  • For those using partitioning, there is now an option to exclude the right-most populated partition from defrags (in theory, the one you’re writing to in a sliding-window scenario).
  • Options such as page count limits and SORT_IN_TEMPDB are now parameterized.
  • I’ve enhanced error logging.
  • … and more!

Right now, I’m looking for a few folks who are willing to beta test the script. If you’re interested, please send me an e-mail at michelle at sqlfool dot com with the editions of SQL Server you can test this on (i.e. 2005 Standard, 2008 Enterprise, etc.).

Thank you! :)

0saves
If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.
Tagged , , , , , . Bookmark the permalink.

7 Responses to Index Defrag Script Updates – Beta Testers Needed

  1. Pingback: Aaron Bertrand

  2. Pingback: Twitted by SQLChicken

  3. Pingback: SQLFool IDX Defrag Scripts » SQL RNNR

  4. Pingback: Log Buffer #176: a Carnival of the Vanities for DBAs | The Pythian Blog

  5. Pingback: Index Defrag Script, v4.0 : SQL Fool

  6. Francois Bourdages says:

    Hi,
    Thanks for you script (http://sqlfool.com/2010/04/index-defrag-script-v4-0/)

    Is there a newest version of it ?
    Was it bug free, after testing it with all the volunteers ?

  7. Howdy! I just wish to give an enormous thumbs up for the great information you could have here on this post.
    I shall be coming again to your blog for more soon.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>