Average Ratings 0 Ratings
Average Ratings 0 Ratings
Description
SQL Index Manager provides a straightforward way to assess the health of your indexes and identify which databases require attention. Users have the option to conduct maintenance via the user interface or create a T-SQL script for execution in SQL Server Management Studio. It allows for the identification of index fragmentation, presenting a comprehensive report that details the extent of fragmentation and the underlying causes. You can address fragmentation by selecting specific indexes to repair, with SQL Index Manager handling the execution of the necessary operations. The tool enables you to choose between reorganizing or rebuilding indexes, with the ability to set personalized thresholds for each action, and if you have SQL Server Enterprise Edition, you can perform online index rebuilds. Furthermore, it supports long-term analysis by allowing you to export your findings to monitor and report on fragmentation trends over time. Additionally, it automatically generates T-SQL scripts to facilitate the process of fixing fragmentation, and users can initiate the rebuilding or reorganizing of chosen indexes with just one click for enhanced efficiency. This seamless integration of features ensures that database maintenance is both effective and user-friendly.
Description
dbForge Index Manager for SQL Server is a user-friendly tool designed to help database specialists detect and resolve index fragmentation issues. It gathers index fragmentation statistics, displays detailed information in a visual interface, identifies indexes in need of maintenance, and provides recommendations for addressing these issues.
Key Features:
- Detailed information about all database indexes
- Customizable thresholds for rebuilding and reorganizing indexes
- Automatic resolving index fragmentation issues
- Generation of scripts for index rebuilding and reorganization with options to save and reuse them
- Exporting index analysis results as detailed reports
- Scanning multiple databases for fragmented indexes
- Efficient index analysis with sorting and searching through
- Task automation for regular index analysis and defragmentation via the command-line interface
dbForge Index Manager integrates seamlessly into Microsoft SQL Server Management Studio (SSMS), allowing users to quickly master its functionality and incorporate it into their workflows.
API Access
Has API
No
API Access
Has API
No
Integrations
SQL
Yes
SQL Server
Yes
SQL Server Management Studio (SSMS)
Yes
Integrations
SQL
Yes
SQL Server
Yes
SQL Server Management Studio (SSMS)
Yes
Pricing Details
$242 per user
Free Trial
Yes
Free Version
No
Pricing Details
$129.95
Free Trial
Yes
Free Version
No
Deployment
Web-Based
Yes
On-Premises
No
iPhone App
No
iPad App
No
Android App
No
Windows
No
Mac
No
Linux
No
Chromebook
No
Deployment
Web-Based
No
On-Premises
No
iPhone App
No
iPad App
No
Android App
No
Windows
Yes
Mac
No
Linux
No
Chromebook
No
Customer Support
Business Hours
No
Live Rep (24/7)
No
Online Support
No
Customer Support
Business Hours
Yes
Live Rep (24/7)
No
Online Support
Yes
Types of Training
Training Docs
Yes
Webinars
No
Live Training (Online)
No
In Person
No
Types of Training
Training Docs
Yes
Webinars
No
Live Training (Online)
Yes
In Person
No
Vendor Details
Company Name
Redgate Software
Founded
1999
Country
United Kingdom
Website
www.red-gate.com/products/sql-index-manager/index
Vendor Details
Company Name
Devart
Founded
1997
Country
United States of America
Website
www.devart.com
Product Features
Product Features
Database
Backup and Recovery
No
Creation / Development
No
Data Migration
No
Data Replication
No
Data Search
No
Data Security
No
Database Conversion
No
Mobile Access
No
Monitoring
No
NOSQL
No
Performance Analysis
No
Queries
No
Relational Interface
No
Virtualization
No