dbForge Index Manager for SQL Server

dbForge Index Manager for SQL Server is an add-in for Microsoft SQL Server Management Studio that extends its capabilities, thus providing users with multiple additional features.

It is designed to simplify the work of SQL Server developers and database administrators by allowing them to analyze the status of various SQL indexes and attempting to fix certain index fragmentation problems. Upon execution, this tool can collect statistics related to index fragmentation and points out databases that might require maintenance.

Users are able to rebuild SQL Server indexes and reorganize them, as well, by relying on the wide variety of features that this add-in packs. It is also possible for developers to generate SQL scripts that they can later use to restore certain troublesome indexes.

dbForge Index Manager for SQL Server allows administrators to perform scans against multiple databases, therefore saving great amounts of time. Connecting to another database automatically refreshes its contents so that users do not need to do that every time they switch between connections.

After the scan processes are finished, this utility displays various useful details related to the troublesome objects, including index size, fragmentation percentage and maintenance priority. It displays recommended actions that need to be taken against corrupted indexes. Users can choose between rebuilding and reorganizing their indexes, according to the severity of the problem.

Aside from the functions mentioned above, dbForge Index Manager for SQL Server allows administrators to keep track of the scan results. It is possible to generate reports and save them as CSV files so that they can be easily accessed later, if needed.