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.

Features

• 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.

• One-click maintenance

  

  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.

• Real-time feedback

  

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