Productivity / Database Tools

Advertisement


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).

  • Platforms:
    Windows, Windows Vista Starter, Windows Vista Home Basic, Windows Vista Home Premium, Windows Vista Business, Windows Vista Enterprise, Windows Vista Ultimate, Windows Vista Home Basic x64, Windows Vista Home Premium x64, Windows Vista Business x64, Windows Vista Enterprise x64, Windows Vista Ultimate x64, Windows 7, Win7 x32, Win7 x64, Windows 8, Windows 8, Win2000, WinOther, WinVista, WinVista x64, Windows Server, WinServer, WinXP,Windows 10,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


  • Similar:
  • Version 1.3 Changes:
    *SQL Server 2016 Service Pack 1 (SP1) new syntax support
    *SQL Server 2017 new syntax support
    *Azure SQL Data Warehouse support




  • License: Shareware
  • Cost: $99.95 USD
  • Size: 344.8 MB
Download    |   Publisher    |   Buy

Related Software

Title / Version / Description Size License
Windows
Restore SQL Server Database 6.0 - Do you want to restore SQL server database? If yes, then download our tool which is perfectly... 3.3 MB Shareware
SQL Digger 2.5 - SQL Digger is a very simple tsql search tool designed for Microsoft SQL Server. It enables you to... 2.4 MB Shareware
SQL Server Recover Resource Database 6.0 - Users can recover system database of SQL Server with SQL resource database recovery software. It... 3.3 MB Shareware
dbForge Studio for SQL Server 4.5 - dbForge Studio for SQL Server is an integrated environment for SQL Server development,... 26.3 MB Shareware
Quick Maintenance and Backup for MS SQL 1.2.16.0 - This program can automatically performs many tasks for DB maintenance on a SQL Server such as:... 31.0 MB Shareware
SQL Server Data Access Components 4.00 - SDAC is a VCL/VCL .NET/CLX component library for fast direct access to SQL Server from Delphi and... 3.8 MB Shareware
SQL Server Recovery Toolbox 2.0.1 - Evaluate the ease of SQL recovery services, using SQL Server Recovery Toolbox and retrieve the... 7.4 MB Shareware
NetWrix SQL Server Change Reporter 2.219.141 - NetWrix SQL Server Change Reporter is a free tool to audit and report on all administrative... 6.0 MB Shareware
Import Table from Excel for SQL Server 1.07.00 - Import Table for Microsoft SQL Server helps to load data from Excel spreadsheet. The program has... 603.0 KB Demo
SQL Server Data Access Components 7.1 - SDAC is a VCL/LCL/FMX component library for fast direct access to SQL Server from Delphi and... 25.7 MB Shareware
Macintosh
SQL Server Data Access Components 7.1 - SDAC is a VCL/LCL/FMX component library for fast direct access to SQL Server from Delphi and... 25.7 MB Shareware
dbExpress driver for SQL Server 6.6 - dbExpress is database-independent layer that defines common interface for fast access and high... 2.4 MB Shareware
Freeware - Navicat Lite for Mac OS X (Cross-Database Admin Tools for MySQL, SQLite, SQL Server, Orac 10.0.0 - Navicat Lite is an ideal solution for MySQL, SQLite, SQL Server, Oracle and PostgreSQL... 28.1 MB Shareware
Navicat Premium (Cross-database Admin Tools for MySQL, SQLite, SQL Server, Oracle and PostgreSQL) for Mac OS X 10.0.0 - Navicat Premium is an ideal solution for MySQL, SQLite, SQL Server, Oracle and PostgreSQL... 33.9 MB Shareware
Navicat for SQL Server Database Client for Mac OS X - Compatible with Mac OS X Snow Leopard! 10.0.0 - Navicat is an ideal solution for SQL Server administration and development. This is an... 21.8 MB Shareware
Linux
dbExpress driver for SQL Server 3.20 - dbExpress driver for MS SQL Server (DbxSda) provides access to MS SQL Server database. It works... 813.1 KB Shareware
dbExpress driver for SQL Server 4.80 - dbExpress driver for MS SQL Server (DbxSda) provides access to MS SQL Server database. It works... 1.4 MB Shareware
dbExpress driver for SQL Server 6.6 - dbExpress is database-independent layer that defines common interface for fast access and high... 2.4 MB Shareware
PDA
SharePoint Data Connector 1.2.508.1 - Data Connector provides a convenient way to access external data completely within SharePoint.... 2.4 MB Shareware
e-SoftEasy Business Analytics 2.0 - Create HTML/PDF Reports/Charts from multiple Database Servers. Filter, sort and group your data... 125.6 KB Freeware

dbForge Index Manager for SQL Server User Reviews

More Reviews or Write Review