Red Gate SQL Index Manager

Quick and easy setup

Choose your server and database and click Diagnose now to begin analysing your database for fragmented indexes.

Configurable fragmentation thresholds

The index fragmentation and size thresholds can be manually specified to set the levels at which fragmentation is reported.

Clear data visualisation

Quickly identify highly-fragmented indexes using the results in the Index Analysis report.

Advice on rebuilding or reorganising

View fragmentation levels and get recommendations on whether to rebuild or reorganise indexes, then fix problems with specific indexes or choose to correct all of them.

One-click maintenance

Start rebuilding or reorganising selected indexes with a single click.

Automatic T-SQL script generation

SQL Index Manager can generate T-SQL scripts or create a SQL Server Job to rebuild/reorganise your indexes.

Real-time feedback

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