Minion Reindex by MidnightDBA is a stand-alone index maintenance module. Once installed, Minion Reindex automatically maintains all online databases on the SQL Server instance, and will automatically incorporate databases and indexes as they are added or removed.
Ten of the very best features of Minion Reindex are, in a nutshell:
- Automated operation – Run the Minion Reindex installation scripts, and it just goes.
- Easy mass installation – Install Minion Reindex on hundreds of servers as easily as you can on one.
- Granular configuration without extra jobs – Configure extensive settings at the default, database, and/or table levels with ease.
- Database and table reindex ordering – Reindex databases and tables in exactly the order you need.
- Flexible include and exclude – Reindex only the databases you want, using specific database names, LIKE expressions, and even regular expressions.
- Live Insight – See what Minion Reindex is doing every step of the way, and how much further it has to go.
- Maximized maintenance window – Spend the whole maintenance window on index maintenance, not on gathering fragmentation stats.
- Extensive, useful logging – Use the Minion Reindex log for estimating the end of the current reindexing run, troubleshooting, planning, and reporting.
- Built in manual runs – Choose to only print reindex statements, and run them individually as needed.
- Integrated help – Get help on any Minion Reindex object without leaving Management Studio.