Analyze individual databases, or multiple databases at once

Select your server and choose to scan and fix fragmentation on a specific database, all User databases, or all System databases.

You can also see the total time taken to complete the fragmentation scan.

Advice on rebuilding or reorganizing

See the suggested action, the reason for fragmentation, and the priority level for a fix.

If you use SQL Server Enterprise, you can also rebuild your indexes online.

Analyze and export fragmentation results

Export the results of the fragmentation analysis as a CSV file for reporting and analyzing fragmentation over time.

Configurable fragmentation thresholds

You can specify what thresholds to report on for index fragmentation and size.

Just configure the option to 'sort in tempdb' and set the common timeout duration.

One-click maintenance

Start rebuilding or reorganizing selected indexes with a single click.

Automatic T-SQL script generation

SQL Index Manager generates T-SQL scripts for use in SQL Server jobs to rebuild or reorganize your indexes.

Real-time feedback

See which indexes SQL Index Manager has rebuilt or reorganized in real time.