Index Defrag Script Updates – Beta Testers Needed

January 26, 2010 by Michelle Ufford
Filed under: Miscellaneous, Performance & Tuning, SQL 2008, Syndication, T-SQL Scripts 

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! :)

Tags: , , , , ,

Comments

4 Comments on Index Defrag Script Updates – Beta Testers Needed

  1. Aaron Bertrand on Tue, 26th Jan 2010 2:51 pm

    2. SQLFool has updated her index maintenance scripts and needs testers!…

    Michelle Ufford ( @SQLFool ) has just announced some shiny new updates to her popular index maintenance…

  2. Twitted by SQLChicken on Tue, 26th Jan 2010 3:29 pm

    3. [...] This post was Twitted by SQLChicken [...]

  3. SQLFool IDX Defrag Scripts » SQL RNNR on Tue, 26th Jan 2010 4:05 pm

    4. [...] http://sqlfool.com/2010/01/index-defrag-script-updates-beta-testers-needed/ Posted by Jason Brimhall at 15:04 Tagged with: clustered index, defrag, Index, Scripts [...]

  4. Log Buffer #176: a Carnival of the Vanities for DBAs | The Pythian Blog on Fri, 29th Jan 2010 12:03 pm

    5. [...] Michelle Ufford has updates on her index defrag script – beta testers are needed. [...]

Tell me what you're thinking...
and oh, if you've enjoyed the post, please consider subscribing to my blog.