dbForge Index Manager for SQL Server Background
dbForge Index Manager for SQL Server Icon

Analyze the status of SQL indexes and fix issues with index fragmentation.

0
Downloads
-
0 Ratings
All Versions
0
Total Downloads
0
Downloads Last Week
Current Version
0
Total Downloads
0
Downloads Last Week
Downloads Last 10 Weeks
All Versions
-
0 Ratings
5
4
3
2
1
Current Version
-
0 Ratings
5
4
3
2
1

dbForge Index Manager for SQL ServerOverview

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

New

Support for SQL Server 2016; Integration into SSMS 2016; Support for the command-line interface.
...

dbForge Index Manager for SQL ServerTech Specs

Version
1.1.77
Date
09.16.16
License
Free to try
Language
English
File Size
14.52MB
Developer
Category
SubCategory
Operating Systems
Windows XP/2003/Vista/7/8/10
System Requirements

.NET Framework 4.5 or higher

SelectedFor You

MySQL Icon
Oracle Corporation
MySQL Community Edition is the world's most popular open source database.
Crystal Reports Server XI Icon
Business Objects SA
Transforming data into actionable information accessible anytime, anywhere
SQL Server 2008 R2 Express Icon
Microsoft Corporation
SQL Server 2008 Express Edition is a free, easy-to-use, lightweight, and embeddable version of SQL Server 2008.
dotConnect for MySQL Professional Icon
Devart
Get a data provider for MySQL built over ADO.NET architecture.
Firebird Icon
Firebird Project
Firebird is a relational database offering many ANSI SQL standard features.
Allegro CL Icon
Franz Inc.
Persistency built in, not a database add-on.
dbForge Studio for MySQL Professional Icon
Devart
Database development and administration environment for MySQL
PostgreSQL Icon
PostgreSQL Global Development Group
PostgreSQL is a powerful, open source object-relational database system.