Editor's review

DbForge Index Manager for SQL Server is an SSMS add-in for managing SQL Server database Index fragmentation. Database indexes can be used to drastically speed up SQL queries and in this way contribute to faster loading apps, web pages and other services, which use SQL Server databases for storing data.

Installation provides support for SSMS versions 2012, 2014, 2016. It also provides an option to generate native images with Ngen.exe to optimize add-in startup.

Add-in features Index manager GUI, from where you can view all indexes, search between them, fix fragmented indexes and perform other related operations. Every index is also shown with details, such as index size, percentage of fragmentation and maintenance priority.

You can also set a few options for scan results threshold level. You can set reorganize and rebuild threshold in percentage of fragmentation, minimum pages of index size, and you can also set to rebuild index online and to sort it in tempdb.

Index fragmentation results can be exported to CSV file. There is also a button to open SQL script for fixing fragmentation in new window or save it directly to clipboard. In this way you will be able to use it later for indexes that need to be rebuild or reorganized often.

DbForge Index Manager for SQL Server offers a unified database index management solution, where you can see all indexes of selected database and quickly identify ones, on which the action must be taken. It supports all the latest SQL Server and SSMS versions, and also comes with a command-line interface support.

Pros

• Possibility to save fragmentation script for later use• Supports all the latest SQL Server and SSMS versions• Command-line interface is supported