Price: $
DbForge Index Manager for SQL Server icon

DbForge Index Manager for SQL Server

1.13.22

    DbForge Index Manager for SQL Server
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
5
/ 60 ratings

SSMS add-in for managing SQL Server database index fragmentation

Devart | 110 more apps |
updated on December 29, 2023
Download
728.2mb | trialware

Pros

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

Cons

None
DbForge Index Manager for SQL Server
Price: $
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.
Reviewed by (editor rating 4 out of 5 stars)
on

Additional info

Minimum requirements

• .NET Framework 4.7.2 or higher installed

Licence limitations

• 30-day trial

Operating system

Windows

Supported languages

English

Downloads

Total: 3
Last week: 1

You might be also interested in