SQL Index Manager

What is SQL Index Manager?

Analyze, manage, and fix database index fragmentation

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

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

Detect index fragmentation:  Get a complete report on the indexes in your databases, including the severity of the fragmentation and the reasons for it.

Repair fragmentation: Choose which indexes to fix based on the severity of the fragmentation - SQL Index Manager will perform the operation for you.

Reorganize or rebuild:  Define the action to take, based on customizable rebuild and reorganization thresholds, and rebuild online indexes with SQL Server Enterprise Edition.

Analysis over time: Export the results of your analysis to track and report fragmentation.

Generate scripts: Generate T-SQL scripts automatically to fix fragmentation.

Analysis of individual databases or multiple databases at once

Select your server and choose to verify and correct fragmentation on a specific database, all user databases, or all system databases.

You can also see the total time required to complete the fragmentation scan.

Advice on reconstruction or reorganisation

See the suggested action, the reason for the fragmentation, and the priority level for a fix.

If you use SQL Server Enterprise, you can also rebuild your online indexes.

Analyze and export fragmentation results

Export the results of the fragmentation analysis as a CSV file to report and analyze the fragmentation over time.

Configurable fragmentation limits

You can specify which limits to report on fragmentation and index size.

Just set the 'sort in tempdb' option and set the common timeout duration.

One-click maintenance

Start rebuilding or rearranging the selected indexes with a single click.

Automatic generation of T-SQL script

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

Real-time feedback

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

System Requirements:

CPU: 1.8 GHz dual core processor

RAM: 2 GB

HDD/SSD: 50 GB of free space on main drive

Operating system: Microsoft Windows 8 32-bit, Microsoft Windows 7 32-bit, and Microsoft Windows Vista 32-bit

Resolution: 1024×768