About DB Optimizer
DB Optimizer is a database optimization tool for tuning poorly performing SQL code. It supports major relational databases like SQL Server, Oracle, and PostgreSQL.
DB Optimizer by IDERA is a database optimization tool designed for developers and DBAs to diagnose and resolve performance issues in SQL code. It provides a unified graphical interface to tune queries across major relational databases, including Microsoft SQL Server, Oracle, PostgreSQL, and Amazon Redshift. Key features include a SQL tuning wizard that suggests improvements, color-coded index analysis, and graphical wait-time analysis to identify performance bottlenecks. The software also allows users to simulate production load to test query performance safely. Pricing is per user workstation and requires a quote, though a starting price is listed. Support is available through various plans, and documentation is provided on the vendor's website.
Pros & Cons
- Supports a wide range of major relational database platforms from a single interface.
- Provides graphical visualization of wait-time analysis to quickly identify performance bottlenecks.
- Includes a SQL tuning wizard that automatically suggests solutions.
- Allows for load testing in a simulated environment to prevent risks to production systems.
- Offers color-coded index analysis with recommendations for optimization.
- Full pricing details require contacting sales for a quote.
- The product is a desktop application, which may not suit teams looking for a fully cloud-based/SaaS solution.
Features
Key features
Tune SQL code on Microsoft SQL Server, Oracle, IBM Db2, SAP Sybase ASE, PostgreSQL, and Amazon Redshift from a single interface.
Automatically suggests solutions and provides context for tuning SQL code.
Shows used, unused, or missing indexes with color-coding and provides recommendations for optimal performance.
Uses graphical visualization of wait-time analysis to pinpoint SQL causing poor database performance.
Verifies the performance of existing and alternative SQL queries in a simulated production environment without risk.
Additional features
Monitors an entire data source within a configurable time span to capture performance data.
Provides insight into how SQL will be executed and the associated performance costs.
Generates all possible cases to find the best alternative to a given SQL statement, including rewrites and join analysis.
Identifies Cartesian joins, implied Cartesian joins, and many-to-many relationships in SQL statements.
Allows sharing of information captured during the profiling process.
Pricing
One-time purchase
- SQL Tuning
- Index Analysis
- Performance Bottleneck Identification
- Load Testing Simulation
Starts at $572.00 per user (workstation). This is a discounted price from $715.00. Volume discounts available. Final price requires a quote.
Source: vendor pricing page →Countries & Languages
Interface languages
Billing currencies
No reviews yet
Be the first to drop a review
Alternatives to DB Optimizer
Cloudsania
Cloudsania is a cloud infrastructure management platform for engineering teams. It excels by reducing the…
Thunders AI Test Agents
Thunders AI Test Agents is a test automation platform from Thunder Code that boosts QA…
Sylabs Cloud
Sylabs Cloud is a container management platform from Sylabs that supports storage and building of…
SingularityPRO
SingularityPRO is a container management software from Sylabs, Inc. that helps in simplifying the deployment…
Spot something wrong or outdated?
Suggest a correction — a reviewer verifies every change.
About DB Optimizer
DB Optimizer is a database optimization tool for tuning poorly performing SQL code. It supports major relational databases like SQL Server, Oracle, and PostgreSQL.
DB Optimizer Details
DB Optimizer's In-App Market Place
Does DB Optimizer have an in-app market place?
Yes
How many Mini-Apps in the marketplace?
6
Mini Apps
SQL Diagnostic Manager for SQL Server: This add-on provides real-time performance monitoring
alerts
and expert advice for optimizing SQL Server performance.
SQL Secure: This add-on helps to secure SQL Server databases by identifying vulnerabilities and monitoring user permissions and activities.
SQL Change Manager: This add-on streamlines database changes by allowing users to compare and synchronize database schemas
as well as track and audit changes.
Pricing Options
Plans
One-time purchase
- SQL Tuning
- Index Analysis
- Performance Bottleneck Identification
- Load Testing Simulation
Starts at $572.00 per user (workstation). This is a discounted price from $715.00. Volume discounts available. Final price requires a quote.
Source: vendor pricing page →Accepted Payment Currencies
USD
Pros & Cons
- Supports a wide range of major relational database platforms from a single interface.
- Provides graphical visualization of wait-time analysis to quickly identify performance bottlenecks.
- Includes a SQL tuning wizard that automatically suggests solutions.
- Allows for load testing in a simulated environment to prevent risks to production systems.
- Offers color-coded index analysis with recommendations for optimization.
- Full pricing details require contacting sales for a quote.
- The product is a desktop application, which may not suit teams looking for a fully cloud-based/SaaS solution.
DB Optimizer's Support Options
Email Address
support@idera.comContact
1-877-464-3372Documentation
https://www.idera.com/support/productdocuments/DB Optimizer's Alternatives
Cloudsania
Cloudsania is a cloud infrastructure management platform for engineering teams. It excels by reducing the…
Thunders AI Test Agents
Thunders AI Test Agents is a test automation platform from Thunder Code that boosts QA…
Sylabs Cloud
Sylabs Cloud is a container management platform from Sylabs that supports storage and building of…
SingularityPRO
SingularityPRO is a container management software from Sylabs, Inc. that helps in simplifying the deployment…
