DB Optimizer

Identify Performance Bottlenecks Immediately

Database profiling provides a graphical visualization of wait-time analysis, making the SQL causing poor database performance easy to pinpoint. Continuous profiling monitors an entire data source within a configurable span of time. Explain plans are provided for a better understanding of how SQL will be executed and the performance costs. Utilize reporting to allow sharing of information captured during the profiling process.

Tune SQL like a Pro!

The SQL tuning wizard automatically suggests solutions and provides essential context in tuning SQL code. Color-coded Index Analysis shows used, not used, or missing indexes and offers recommendations for optimum performance. Case Generation enables database optimization by generating all possible cases and finding the best alternative to a given SQL statement by including SQL rewrites and hint injections.

.

Visually Tackle Complex SQL Queries

Unique in the industry, Visual SQL Tuning (VST) diagrams turn text-based SQL code into graphical SQL diagrams. This approach helps DBAs and developers understand the impact of SQL statements on the database. The Visual SQL Tuning (VST) diagram displays indexes and constraints on tables and views with table statistics, as well as the joins used in a SQL statement such as Cartesian joins, implied Cartesian joins and many-to-many relationships.

Simulate Production Environments

Load testing verifies performance of existing and alternative SQL queries against the database. Configure queries to run multiple times in parallel and see how they respond to your simulated production environment without the risk of actually testing in production. Explore Ready, Set Load Test to learn more about how load testing can affect your business.

Become Proactive in Data Governance Compliance

DB Optimizer's ability to identify bottlenecks via database profiling, tune SQL, and load test gives organizations an advantage in ensuring database optimization, uptime, and availability. This functionality gives DBAs and developers the ability to be proactive in identifying performance problems, and complying with Data Governance performance and availability standards.

Get to know DB Optimizer

System Requirements

Minimum hardware requirements:

• Pentium 4-level processor
• 1 GB of Memory
• 1 GB of free disk space
• 1024 x 768 display

DB Optimizer is supported on the following operating systems:

• Windows 8
• Windows 7, 32 and 64 bit
• Windows Server 2008, 32 and 64 bit
• Windows Vista, 32 and 64 bit
• Windows XP, 32 and 64 bit
• Windows 2003
• Linux, x86-32, GTK 2
  • Red Hat Enterprise Linux 5.0
  • SuSe Linux Enterprise Server 10

DB Optimizer Product Editions

DB Optimizer is available in two editions – Developer and Professional, both of which have platform-specific and XE versions.

Developer Edition – Designed for the proactive Database Developer to optimize their SQL code through identification of database bottlenecks and load testing of their SQL code. Modification of SQL code can be done in the SQL IDE and with the assistance of visual SQL tuning diagrams.

Professional Edition – Designed for the performance DBA in need of identifying database bottlenecks, and fixing slow running SQL queries through DB Optimizer's SQL tuning and load testing capabilities. Also includes Advanced Profiling capabilities (Oracle only) allowing DBAs to continuously monitor database activity over a period of time.

Platform-specific Versions – These products support one major platform. DB Optimizer for Oracle, DB Optimizer for SQL Server, DB Optimizer for Sybase, and DB Optimizer for DB2 are available.

XE Version – Grants the license holder the ability to connect to multiple supported database platforms within the same User Interface, with no need to purchase additional platform-specific software. These users can connect to Oracle, SQL Server, Sybase, and DB2 (LUW) platforms simultaneously.