Ratings and Reviews 0 Ratings

Total
ease
features
design
support

This software has no reviews. Be the first to write a review.

Write a Review

Ratings and Reviews 0 Ratings

Total
ease
features
design
support

This software has no reviews. Be the first to write a review.

Write a Review

Alternatives to Consider

  • AdRem NetCrunch Reviews & Ratings
    156 Ratings
    Company Website
  • RaimaDB Reviews & Ratings
    12 Ratings
    Company Website
  • MongoDB Atlas Reviews & Ratings
    1,650 Ratings
    Company Website
  • AddSearch Reviews & Ratings
    140 Ratings
    Company Website
  • UnForm Reviews & Ratings
    19 Ratings
    Company Website
  • Acuity Scheduling Reviews & Ratings
    6,294 Ratings
    Company Website
  • Couchbase Reviews & Ratings
    415 Ratings
    Company Website
  • Budgyt Reviews & Ratings
    282 Ratings
    Company Website
  • Authologic Reviews & Ratings
    2 Ratings
    Company Website
  • JSCAPE MFT Server Reviews & Ratings
    188 Ratings
    Company Website

What is SQL Index Manager?

SQL Index Manager offers an intuitive method for evaluating the condition of your indexes and pinpointing which databases need attention. It gives users the flexibility to either perform maintenance through a graphical interface or generate a T-SQL script suitable for use in SQL Server Management Studio. The tool effectively identifies index fragmentation and provides a detailed report outlining the severity of the fragmentation along with the root causes. Users have the option to target specific indexes for repair, with SQL Index Manager taking care of the required operations seamlessly. You can choose to either reorganize or rebuild indexes while setting custom thresholds for each method, and those utilizing SQL Server Enterprise Edition can take advantage of online index rebuilds. Moreover, it facilitates long-term monitoring by enabling the export of findings, which helps in tracking and analyzing fragmentation trends over time. It also produces T-SQL scripts automatically to streamline the fragmentation-fixing process, allowing users to initiate the rebuilding or reorganizing of selected indexes with a single click, thereby improving efficiency. The combination of these features not only simplifies database maintenance but also enhances its effectiveness, making it an invaluable tool for database administrators. Additionally, the ability to customize maintenance strategies further empowers users to optimize their database performance.

What is DB Optimizer?

DB Optimizer empowers database administrators to analyze and enhance SQL code across various platforms. It provides automated suggestions for SQL tuning and performance improvements, featuring color-coded assessments of stored routines or entire databases. Additionally, the tool includes SQL stress load testing, which mimics production conditions by simulating multiple users and executions over designated time frames. Furthermore, it allows users to evaluate SQL execution and performance costs through the use of explain plans, ensuring optimal database performance. This comprehensive approach helps in efficiently managing and fine-tuning database operations.

Media

Media

Integrations Supported

SQL Server
IBM Db2
Oracle Database
SAP Adaptive Server Enterprise (ASE)
SQL
SQL Server Management Studio (SSMS)

Integrations Supported

SQL Server
IBM Db2
Oracle Database
SAP Adaptive Server Enterprise (ASE)
SQL
SQL Server Management Studio (SSMS)

API Availability

Has API

API Availability

Has API

Pricing Information

$242 per user
Free Trial Offered?
Free Version

Pricing Information

$572 per user (workstation_
Free Trial Offered?
Free Version

Supported Platforms

SaaS
Android
iPhone
iPad
Windows
Mac
On-Prem
Chromebook
Linux

Supported Platforms

SaaS
Android
iPhone
iPad
Windows
Mac
On-Prem
Chromebook
Linux

Customer Service / Support

Standard Support
24 Hour Support
Web-Based Support

Customer Service / Support

Standard Support
24 Hour Support
Web-Based Support

Training Options

Documentation Hub
Webinars
Online Training
On-Site Training

Training Options

Documentation Hub
Webinars
Online Training
On-Site Training

Company Facts

Organization Name

Redgate Software

Date Founded

1999

Company Location

United Kingdom

Company Website

www.red-gate.com/products/sql-index-manager/index

Company Facts

Organization Name

IDERA, an Idera, Inc. company

Date Founded

2004

Company Location

United States of America

Company Website

www.idera.com/dboptimizer-sql-database-optimization

Categories and Features

Categories and Features

Database

Backup and Recovery
Creation / Development
Data Migration
Data Replication
Data Search
Data Security
Database Conversion
Mobile Access
Monitoring
NOSQL
Performance Analysis
Queries
Relational Interface
Virtualization

Database Monitoring

Anomaly Detection
Autodiscovery
Capacity Planning
Dashboard
Dependency Tracking
Historical Trend Analysis
Multitenancy
Notifications / Alerts
Performance Monitoring
Permissions / Access Controls
Predictive Analytics
Prioritization
Query Analysis
Resource Optimization
Troubleshooting

SQL Server

CPU Monitoring
Credential Management
Database Servers
Deployment Testing
Docker Compatible Containers
Event Logs
History Tracking
Patch Management
Scheduling
Supports Database Clones
User Activity Monitoring
Virtual Machine Monitoring

Popular Alternatives

Popular Alternatives

SQL Query Tuner Reviews & Ratings

SQL Query Tuner

IDERA, an Idera, Inc. company
SQL Defrag Manager Reviews & Ratings

SQL Defrag Manager

IDERA, an Idera, Inc. company
SQL Diagnostic Manager for SQL Server Reviews & Ratings

SQL Diagnostic Manager for SQL Server

IDERA, an Idera, Inc. company
DBF Manager Reviews & Ratings

DBF Manager

Astersoft
DB PowerStudio Reviews & Ratings

DB PowerStudio

IDERA, an Idera, Inc. company