Embarcadero DB Optimizer

Published By:

Embarcadero

Embarcadero DB Optimizer maximises database and application performance by enabling DBAs and developers to quickly discover, diagnose, and optimise poor-performing SQL. DB Optimizer eliminates performance bottlenecks by identifying data intensive or frequently executed queries, focusing on specific SQL statements through query statistics (CPU, I/O, wait times), and fine-tuning problematic statements.

Optimise SQL performance throughout the development lifecycle
Eliminate performance bottlenecks in production databases and applications
Develop, test, profile, and tune SQL in a single, easy-to-use IDE

Product Variants

Embarcadero DB Optimizer, Professional Edition - Maintenance

Embarcadero DB Optimizer, Professional Edition - New Licence

New Features

Continuous profiling lets you monitor performance within a configurable span of time so you can see the effects of your tuned statements immediately
Complete cross-platform support so you can profile and tune in DB2 for LUW, Oracle, SQL Server and Sybase.
A complete UI reorganization based on three main functionalities: SQL profiling, SQL tuning and SQL editing. The new UI simplifies workflow when analyzing queries across the enterprise and increases productivity.
Full Unicode support
Command line interface lets you launch profiling sessions remotely

Features

SQL Profiling

Graphical visualisation of wait-time analysis to easily pinpoint the SQL causing poor database performance
Continuous profiling monitors an entire datasource within a configurable span of time
Explain plans for a better understanding of how SQL will be executed and the performance costs
All data and metadata pertaining to a profile session can be saved as a single entity into an archive file so profiles can be shared.

SQL Tuning

Batch tuning of DML statements, stored routines, and entire SQL files
Case Generation is used to generate all possible cases and find the best alternative to a given SQL statement including SQL rewrites and hint injection

Reporting

Profile chart shows the CPU, I/O, and other wait activity over the course of the profile session
Execution statistics provide detailed information about the profiled SQL and wait categories
Explain plans for each SQL statement can be computed on demand in the Execution Statistics table

SQL Editing

Includes a powerful SQL IDE geared to the needs of application developers
Real-time quick fixes flag and correct inefficient SQL automatically
SQL code assist and real-time SQL syntax validation
Project-level SQL file cataloging and search features

General

Full support for DB2 for LUW, Oracle, SQL Server and Sybase ASE.
Full Unicode support
Command line interface