SQL Index ManagerSQL Index Manager

Redgate SoftwareDatabase Optimization Tools
Version 1.1 (Mar 20, 2017)

Manage and repair SQL Server index fragmentation efficiently.

  • Analyzes index fragmentation across multiple SQL Server databases.
  • Provides customizable options to rebuild or reorganize indexes.
  • Generates T-SQL scripts for scheduled index maintenance.
Redgate Software logo

Prices from:

Loading...
Available individuallyOur Price
SQL Index ManagerLoading
Analyze, manage, and fix database index fragmentation.
SQL Index Manager provides database administrators with comprehensive tools to detect and resolve index fragmentation in SQL Server databases. It supports in-depth analysis, recommended maintenance actions, and customizable repair tasks, helping maintain database performance through a straightforward interface or generated scripts.

Multi-database analysis

Scan individual or multiple SQL Server databases at once to obtain detailed fragmentation reports, including fragmentation severity and underlying causes, helping prioritize maintenance tasks.

Fragmentation detection and reporting

Generates full reports on index fragmentation status, providing clear insights into index health across user and system databases with severity ratings and fragmentation causes.

Customizable maintenance actions

Define thresholds for when to reorganize or rebuild indexes, allowing tailored maintenance operations based on fragmentation severity and index size criteria to optimize performance.

One-click index maintenance

Execute rebuild or reorganize operations on selected indexes quickly through the user interface, simplifying routine maintenance tasks with minimal effort.

Online index rebuild support

For SQL Server Enterprise Edition users, supports online index rebuilds to minimize downtime and maintain availability during index maintenance processes.

T-SQL script generation

Automatically creates T-SQL scripts for rebuilding or reorganizing indexes, enabling integration with SQL Server Management Studio and automation of maintenance jobs.

Exportable analysis results

Allows export of fragmentation analysis data as CSV files, facilitating tracking, reporting, and long-term monitoring of index fragmentation trends.

Real-time feedback

Provides live status updates during index maintenance operations, showing progress on indexes being rebuilt or reorganized for transparency and monitoring.

Configurable scanning parameters

Offers options to adjust scanning behavior such as sorting in tempdb and setting timeouts, enabling fine-tuning of performance and resource usage during fragmentation assessments.

Product Compatibility

Review the details below to ensure this product is supported within your environment.

Operating System

  • Windows Desktop
  • Windows Server

Windows Desktop Version

  • Windows 10
  • Windows 8.1
  • Windows 8
  • Windows 7

Windows Server Version

  • Windows Server 2012