DbForge Index Manager for SQL Server

1.3.77

SSMS add-in for managing SQL Server database index fragmentation

  • Maintenance Recommendations
  • Scan Results Export
  • Customizable Tresholds
  • Script Generation
  • Command-Line Automation
Devart  |  61 more applications - November 22, 2017
Click to rate (0 ratings):
Download (353.1MB)
trialware



Editor's review

DbForge Index Manager for SQL Server 1.1.77reviewed by Tony Hill on 4 star rating4 star rating4 star rating4 star rating4 star rating(4/5)
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
Cons
• None


Gallery


What's new in this version

• SQL Server 2016 Service Pack 1 (SP1) new syntax support
• SQL Server 2017 new syntax support
• Azure SQL Data Warehouse support


Minimum requirements

• .NET Framework 4.5 or higher installed


Trial limitations

• 30-day trial


Previous versions




Additional info

Operating system: Win NT, Win 2000, Win ME, Win XP, Win Server 2003, Win Vista, Win Vista 64 bit, Win Server 2008, Win 7, Win 7 64 bit, Win Server 2008 R2, Win 8, Win Server 2012, Win 10, Win Other, Win Server

Uninstaller: included

Supported languages: English

Release date: 2017-08-30

Downloads: 0

Downloads last week: 0


Comments