SQL Index Manager

dbForge Index Manager is an SSMS add-in that helps database administrators easily identify and fix indexes in SQL Server databases. A smart visual interface and CLI support enable both instant rebuilding or reorganizing indexes and automating tasks with customizable SQL scripts generated by the tool.

  • Gain deep insight into the status of database indexes
  • Detect the fragmentation of indexes across databases
  • Fix index fragmentation based on fragmentation severity
  • Rebuild or reorganize indexes based on thresholds
  • Generate scripts to execute index-related commands
  • Export index analysis results to report on fragmentation
  • Automate index analysis and maintenance jobs via CLI

Features

  • Get maintenance tips

Multiple databases scan

With the help of this tool, you can:

  • Get the overall picture of a database and its specific objects for better fine-tuning
  • Utilize a flexible choice of connections and databases
  • Switch between analyzed objects at any time
  • Use a convenient combo box with user connections
  • Speed up your work process with the auto-refresh functionality triggered upon switching between databases
Get free trial

Maintenance recommendations

After scanning and checking index fragmentation in a SQL Server database, you can sort and search the results to simplify the selection of necessary indexes. Index Manager will show the following information about indexes:

  • Actions you should take with indexes: rebuild or reorganize
  • Index size
  • Fragmentation percentage
  • Reason for fragmentation
  • Maintenance priority
Get free trial

Customizable index fragmentation thresholds

Set up available actions in the way that best suits your needs. The tool allows you to adjust the display of the index scan results with the following options and capabilities:

  • Reorganize and rebuild threshold level
  • Set the minimum index size
  • Choose the index rebuild method: online or offline
  • Restore default options
Get free trial

Exporting scan results

After scanning your databases, you can use the scan results in the following ways:

  • Save them to a CSV file to perform further in-depth index fragmentation analysis
  • Generate a report on the state of index fragmentation in your database with the help of the CSV export feature
Get free trial

Scripts 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 rebuilding or reorganization)
Get free trial

Routine tasks automation

Efficient index management can also be achieved via the command-line interface:

  • View the results of the index analysis, including the name, reason, and fragmentation threshold
  • Create PowerShell automation scripts via the CLI
  • Save your scripts as command-line execution files (.bat) to either schedule their execution via the Windows Scheduler or run them when required
  • Configure settings depending on your needs and save them for later use
Get free trial

Index Manager included in dbForge SQL Tools bundle

dbForge Index Manager

Starts from

$119.95
per year
Try the tool

Key features

  • Multiple database scanning
  • Maintenance recommendations
  • Tune fragmentation thresholds
  • Script generation
  • Index rebuilding
  • Export of scan results
  • Index status tracking
  • Command-line automation
Save 60% with the bundle

dbForge SQL Tools

Starts from

$429.95
per year
Try the complete bundle

Includes 15 tools:

Trusted by thousands of data-driven companies
Barkley
Arconic
Polaris
Jabil
HP
Lam
Microsoft
Trusted by thousands of data-driven companies
Barkley Arconic Polaris Jabil HP Lam Microsoft

Ready to get started?

Get a 30-day trial

Get a 30-day trial

Download a FREE 30-day trial of dbForge Index Manager and start solving fragmentation issues most effectively.

Get started
Multiple licenses discount

Multiple licenses discount

We offer flexible options to meet your budget in the optimal way. When purchasing multiple licenses, you get a bulk discount.

Discover now
Need a hand?

Need a hand?

If you need any help or have questions about our tools or purchasing options, just get in touch with our team.

Contact us

Frequently asked questions

What fragmentation metrics does dbForge Index Manager report, and how are they calculated?

After scanning the database, dbForge Index Manager provides the complete information about the indexes that require maintenance, including the index name, type, and size. It calculates the index fragmentation score in percent and provides recommendations on rebuilding or reorganizing the specific index based on that score and the thresholds set.

How does it decide between REORGANIZE and REBUILD, and can thresholds be customized?

Rebuilding is recommended when the fragmentation score is higher than 30%, while reorganization is recommended if the fragmentation score is higher than 10% but less than 30%. These thresholds are default, but you can customize these values in the Options menu.

Can I scan multiple servers/databases and filter by schema, table, or index type?

Yes, you can scan as many servers and databases as you need. When the scanning is complete, you can filter the results by schema, specific table, and index type. For that, click the filter glyph on the desired column header. Also, there is the possibility to create custom filters based on the text.

How do I schedule unattended maintenance via CLI and Windows Task Scheduler?

You can automate index management using the command line. For each task, you can save the settings as an executable .bat file. Just click the Options button in the Index Manager window, and you'll see the Save Command Line option there. Index Manager will create that executable file for you, and you can also edit it if necessary. The detailed information on the available options is available in the official documentation. Further, you can use the .bat file to run the task automatically on demand or regularly on schedule using Windows Task Scheduler.

Does it support online rebuilds and edition-specific features (Enterprise vs Standard)?

dbForge Index Manager allows rebuilding indexes while the database remains online and available for use. For example, when one user is rebuilding an index, other users can update and query the table data without interruption. This option is turned off by default; you need to enable it manually in the Options menu. As for the edition-specific features, the Index Manager add-in is available in the Professional or Enterprise editions of dbForge SQL Tools, not in the Standard edition. The functionality of the add-in is the same in both Professional and Enterprise editions.

What T-SQL scripts are generated, and can I export them for change control/CI?

dbForge Index Manager can automatically generate T-SQL scripts to rebuild or reorganize specific indexes. You can save these scripts and run them against a database when needed. To generate such a script, select the necessary index(es) and click Script Changes. By default, a newly generated script opens in a new SQL document, which you can save. Also, you can copy the generated script to the clipboard at once.

What is the expected performance impact, and how can I minimize it during maintenance windows?

dbForge Index Manager does not require lots of resources to work and does not impact the overall performance. Still, you can use the option to automate the index analysis, reorganization, and rebuilding tasks, and run these tasks on schedule during the maintenance windows, especially when handling massive databases.