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
    165 Ratings
    Company Website
  • RaimaDB Reviews & Ratings
    12 Ratings
    Company Website
  • Sumsub Reviews & Ratings
    236 Ratings
    Company Website
  • UnForm Reviews & Ratings
    19 Ratings
    Company Website
  • Acuity Scheduling Reviews & Ratings
    6,346 Ratings
    Company Website
  • ZenTreasury Reviews & Ratings
    9 Ratings
    Company Website
  • Couchbase Reviews & Ratings
    417 Ratings
    Company Website
  • LeaseAccounting.app Reviews & Ratings
    Company Website
  • Budgyt Reviews & Ratings
    291 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
SQL
SQL Server Management Studio (SSMS)

Integrations Supported

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

API Availability

API Availability

Pricing Information

$242 per user
Free Trial Offered?

Pricing Information

$572 per user (workstation_
USD 572 per user (workstation) with first year maintenance included; pricing for new customers only
Free Trial Offered?

Supported Platforms

SaaS

Supported Platforms

Windows

Customer Service / Support

Not specified

Customer Service / Support

Standard Support
Web-Based Support

Training Options

Documentation Hub

Training Options

Documentation Hub
Webinars

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

Monitoring
Performance Analysis
Queries

Database Monitoring

Anomaly Detection
Dashboard
Historical Trend Analysis
Performance Monitoring
Query Analysis

SQL Server

Deployment Testing
History Tracking

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
SQL Sentry Reviews & Ratings

SQL Sentry

SolarWinds