SQL Index Manager – analyze, manage, and fix database index fragmentation
SQL Index Manager enables you to quickly and easily find out the status of your indexes and discover which databases need maintenance. You can then choose to perform the maintenance task required through the UI, or view the T-SQL script to execute the command via SSMS.
- Detect index fragmentation: get a full report of the status of your indexes.
- Save time: quickly and easily discover which databases need maintenance.
- Fix problems: view and perform the maintenance task required.
Quick and easy setup
Choose your server and database and click Diagnose now to begin analyzing 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 visualization
Quickly identify highly-fragmented indexes using the results in the Index Analysis report
Advice on rebuilding or reorganizing
View fragmentation levels and get recommendations on whether to rebuild or reorganize indexes.
Then fix problems with specific indexes, or choose to correct all of them.
Start rebuilding or reorganizing 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 or reorganize your indexes.
See which indexes SQL Index Manager has rebuilt or reorganized in real time.