Idera DB Optimizer

Automated SQL profiling and query tuning
Buy now Contact

Publisher

Idera

Subcategories

Database IDEs & Administration

Average rating

Deze score is berekend door AI op basis van publiek beschikbare informatie.
3.5 / 5

About this software

DB Optimizer is a SQL optimization and profiling tool for database professionals. It discovers, diagnoses, and helps optimize poor-performing SQL by combining a SQL IDE, automated tuning suggestions, visual SQL tuning diagrams, and execution profiling. The product offers continuous data source profiling, index analysis, hint injection, explain plans, and load-test simulations to evaluate alternative queries. It supports tuning across multiple relational databases from a single interface.

Licenses & prices

Database artisan + database optimizer for sap sybase

Combines Database Artisan IDE with DB Optimizer features tailored for SAP Adaptive Server Enterprise (Sybase) performance tuning.

Database optimizer all platform

DB Optimizer all platform edition provides query analysis, indexing, and workload tuning across all supported database platforms.

Database optimizer single platform

DB Optimizer single platform edition delivers query tuning, index recommendations, and workload analysis for one database platform.

Purchase

Idera DB Optimizer

Idera DB Optimizer
In Stock
Delivery: 1 working day
Loading...
€163.93
Free and without obligation

Do you need more information or looking for another license?

envelope Get in contact phone Call me calendar Schedule a meeting

Benefits

  • Multi-DBMS support: Supports multiple major relational database platforms from one interface
  • Automated SQL tuning: Provides automated tuning suggestions, hint injection, and case generation
  • Visual query diagrams: Visual SQL Tuning diagrams display joins, indexes, and query impact
  • Profiling and diagnostics: Continuous profiling surfaces top SQL, waits, sessions, and execution statistics
  • Load testing: Simulate parallel users and executions to validate query performance

Available languages

  • English

Support information

  • Product documentation: Comprehensive user guides, quick start guides, and release notes are available on IDERA's documentation site
  • Support portal: IDERA operates a support portal with product documents, knowledge articles, and downloads
  • Training and demos: Videos, demos, and product tour resources are available on IDERA's resource center
  • Session sharing: Profiling sessions can be saved to archive files and shared across workspaces and machines
  • Command line API: A command line API enables remote launching of profiling and tuning sessions

Frequently asked questions

Which database platforms does DB Optimizer support?
DB Optimizer supports Microsoft SQL Server, Oracle Database, IBM Db2 LUW, SAP Sybase ASE, PostgreSQL, Pivotal Greenplum, and Amazon Redshift.
What tuning features does DB Optimizer provide?
Features include an SQL tuning wizard, index analysis, hint injection, SQL rewrites, explain plans, and case generation.
How does DB Optimizer profile database performance?
It continuously profiles data sources, samples workload, and presents wait-time analysis, execution statistics, and profiling charts for drill-down.
Can DB Optimizer simulate production workloads?
Yes. Load testing can run parallel query executions to simulate production-like conditions and evaluate alternatives.
What interfaces and integrations are available?
Available as a standalone application or Eclipse plug-in and supports JDBC connectivity for other DBMSs.