dbForge Index Manager for SQL Server

SSMS add-in for analyzing status of SQL indexes and fixing issues with indexes

dbForge Index Manager for SQL Server is an SSMS add-in for analyzing the status of SQL indexes and fixing issues with index fragmentation. The tool allows you to quickly collect index fragmentation statistics and detect databases that require maintenance. You can instantly rebuild and reorganize SQL indexes in visual mode or generate SQL script for the future use. dbForge Index Manager for SQL Server will significantly boost SQL Server performance without much effort. Key features: Multiple Databases Scan. The tool allows to get an overall picture of a database as well as its specific objects for better fine-tuning. Flexible choice of connections and databases allows to easily switch between analized objects. Among other advantages are a combo box with user connections and auto-refresh upon switching between databases. Maintenance Recommendations. After scanning, Index Manager will prompt what actions must be taken against indexes - Rebuild or Reorganize. Sorting and searching simplifies the selection of necessary indexes. The tool also shows: - Index size - Fragmentation percentage - Reason for fragmentation - Maintenance priority Export of Scan Results. The scan results can be saved to output file in the CSV format for further index fragmentation analysis or for the sake of reporting. You can generate reports on the state of indexes in your database using the CSV export. Customizable Index Fragmentation Thresholds. Set up available actions in the way which is best for you. The tool allows to set up index scan results with the following options: - Reorganize threshold level - Rebuild threshold level - Minimum index size Script Generation. With dbForge Index Manager, you can generate T-SQL scripts to execute index rebuild and index reorganization commands. Use Script Changes to save a script for the set of indexes that are often fragmented (require frequent rebuild or reorganization).

Changes: *Compliance with the Federal Information Processing Standard (FIPS) *Trial product activation implemented *Greatly improved visual style of the application with high DPI support *Specific exit codes added

Minimum requirements: .NET Framework 4.5 or higher installed

Operating system: Win2000,WinXP,Win7 x32,Win7 x64,Windows 8,Windows 10,WinServer,WinOther,Windows2000,Windows2003,Windows Server 2000,Windows Server 2003,Windows Server 2008,Windows Server 2008r2,Windows Server 2012,Windows Tablet PC Edition 2005,Windows Media Center Edition 2005,WinVista,Windows Vista Starter,Windows Vista Home Basic,Windows Vista Home Premium,Windows Vista Business,Windows Vista Enterprise,Windows Vista Ultimate,WinVista x64,Windows Vista Home Basic x64,Windows Vista Home Premium x64,Windows Vista Business x64,Windows Vista Enterprise x64,Windows Vista Ultimate x64

Program URL: http://www.devart.com/dbforge/sql/index-manager/

G+ Linikedin Twitter Facebook

dbForge Index Manager for SQL Server screenshot

...

Special permissions

See End-User License Agreement

EULA

License Agreement IMPORTANT - READ BEFORE COPYING, INSTALLING OR USING. Do not use or load this software and any associated materials (collectively, the "Software") until you have carefully read the following terms and conditions. By loading or using the Software, you agree to the terms of this Agreement.

Read more