Analyze and Fix SQL Indexes

dbForge Index Manager for SQL Server is a handy SSMS add-in for analyzing the status of SQL indexes and fixing issues with index fragmentation.

The tool allows you to quickly collect index fragmentation statistics and detect databases that require maintenance. You can instantly rebuild and reorganize SQL indexes in visual mode or generate SQL script for the future use. dbForge Index Manager for SQL Server will significantly boost SQL Server performance without much effort!

How dbForge Index Manager for SQL Server Can Help DBAs and Developers?


  • Gives a thorough insight into the status of SQL indexes within your databases.
  • Helps making a right decision on managing index fragmentation in SQL Server.
  • Enables fine-tuning of index fragmentation and setting up scan results thresholds.
  • Displays comprehensive index-related statistics to detect databases that require maintenance.
  • Allows to generate T-SQL scripts to rebuild and reorganize indexes that are frequently managed.
  • Enables the export of scan results to analyze or report on index fragmentation.

Key Features

Multiple Databases Scan

The tool allows to get an overall picture of a database as well as its specific objects for better fine-tuning. Flexible choice of connections and databases allows to easily switch between analyzed objects. Among other advantages are a combo box with user connections and auto-refresh upon switching between databases.

Maintenance Recommendations

After scanning, Index Manager will prompt what actions must be taken against indexes - Rebuild or Reorganize. Sorting and searching simplifies the selection of necessary indexes. The tool also shows:

  • Index size
  • Fragmentation percentage
  • Reason for fragmentation
  • Maintenance priority

Export of Scan Results

The scan results can be saved to output file in the CSV format for further index fragmentation analysis or for the sake of reporting. You can generate reports on the state of indexes in your database using the CSV export.

Customizable Index Fragmentation Thresholds

Set up available actions in the way which is best for you. The tool allows to set up index scan results with the following options:

  • Reorganize threshold level
  • Rebuild threshold level
  • Minimum index size

Script Generation

With dbForge Index Manager, you can generate T-SQL scripts to execute index rebuild and index reorganization commands. Use Script Changes to save a script for the set of indexes that are often fragmented (require frequent rebuild or reorganization).

Command-Line Automation

The tool includes the command-line interface allowing you to automate your routine index management tasks.

Customer Loyalty Programs

Send us a link to your MVP profile and get a free license for any SQL Server product from Devart range!

MS MVP

Get significant discounts, and even free licenses for spreading a word about dbForge Source Control.

Devart High Five Program for dbForge Source Control for SQL Server

Get 50% OFF for switching to dbForge Source Control for SQL Server tools from competing tools!

SQL Source Control Competitive Upgrade

dbForge Developer Bundle for SQL Server

An ultimate kit of twelve database development and management tools in one package. Grab the full power of dbForge Developer Bundle for SQL Server and benefit from a sensational discount in comparison with buying tools separately.

Developer Bundle Save up to 25