Quickly and easily find out the status of your indexes and discover which databases need maintenance.
Detect index fragmentation: get a full report on indexes across your databases, including severity of fragmentation and the reasons for it.
Fix fragmentation: choose which indexes to fix based on fragmentation severity – SQL Index Manager will perform the operation for you.
Reorganize or rebuild: set which action to take, based on customizable rebuild and reorganization thresholds, and rebuild indexes online with Microsoft SQL Server Enterprise Edition.
Analyze over time: export the results of your analysis to track and report on fragmentation. Generate scripts: automatically generate T-SQL scripts to fix fragmentation.