SQL Index Manager

Analyze, manage, and fix database index fragmentation

Download 14-day free trial

Introduction to SQL Index Manager

SQL Index Manager lets you quickly and easily find out the status of your indexes and discover which databases need maintenance.

You can do maintenance through the UI, or generate a T-SQL script to run in SQL Server Management Studio.

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

$145 per user

Download free trial

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.

Analyze individual databases, or multiple databases at once

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.

Advice on rebuilding or reorganizing

Analyze and export fragmentation results

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

Analyze and export fragmentation results

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.

Configurable fragmentation thresholds

One-click maintenance

Start rebuilding or reorganizing selected indexes with a single click.

One-click maintenance

Automatic T-SQL script generation

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

Automatic T-SQL script generation

Real-time feedback

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

Real-time feedback

SQL Index Manager

Get started with SQL Index Manager

Download a 14-day trial of SQL Index Manager

Download free trial

Need a hand?

If you'd like any help, or have a question about our tools or purchasing options, just get in touch.