dbForge Index Manager for SQL Server
Features Overview

If you have been administering an SQL database for a considerable period of time, most probably, you have already faced a problem with the index fragmentation issues. The database engine automatically changes indexes each time an insert, update, or delete operation is performed on the underlying data. Over time, these changes accumulate and scatter the index around the database in no particular order. This is when dbForge Index Manager takes the spotlight.

The tool allows you to quickly collect index fragmentation statistics and detect databases that require maintenance to properly function. You can instantly rebuild and reorganize SQL Server indexes in visual mode or generate SQL scripts for future use. Significantly boost your performance and save a lot of time with dbForge Index Manager.

Multiple Databases Scan

With this feature, you will be able to get the overall picture of databases and their specific objects. This helps to fine-tune the databases and speed up your work process with the auto-refresh functionality triggered upon switching between databases.

Check out the convenient combo box that allows you to easily switch between connections, databases, and analyzed objects at any time.

Multiple Databases Scan

Maintenance Recommendations

The benefits of the tool are not limited to a simple SQL Server database scan for fragmented indexes. Sort and search the scan results in order to single out only those you need. Once the scan is over, the following details will be displayed: the size of the indexes, fragmentation reason and percentage, maintenance priority, as well as whether it is recommended to rebuild or reorganize the indexes.

dbForge Index Manager

Index Fragmentation Thresholds

You can organize the index scan results according to your needs. Reorganize and rebuild the threshold level, set the minimum index size, choose the index rebuild method, and, if necessary, restore the options back to default.

Customizable Index Fragmentation Thresholds

Script Generation

Generate T-SQL scripts based on the performed actions and save them to execute index rebuild and index reorganization commands later. Script Changes can be a lifesaver for the indexes that are frequently manipulated (fragmented). You will save a lot of time by simply executing the previously saved scripts instead of going through the whole process every time from the very beginning.

Script Generation

Exporting Scan Results

You are only a few clicks apart from exporting the scan results as a CSV file directly from SSMS. Simply click the Export to CSV button, choose a place on your computer to store it, and you are done.

The CSV export feature can be useful to perform further in-depth index fragmentation analysis or to generate a report on the state of index fragmentation in your database.

Exporting Scan Results

Routine Task Automation

If you are willing to perform regular scans to detect fragmented indexes, you do not have to do it manually: efficient index management can also be accomplished via the command line. All you need to do is set the options according to your needs and click the Save Command Line button. This will save your scripts as command-line execution files (.bat) to either schedule their execution via Windows Scheduler or run them when required.

Index management using command line

SSMS Integration

Just like many other dbForge tools, Index Manager can be easily integrated into Microsoft SQL Server Management Studio. The solution brings smart index fixing and index fragmentation right into it. Enjoy all the benefits of the tool right from SSMS.

Index Manager - SSMS Integration