Key Features:

• Graphical visualization of wait-time analysis
• Continuous profiling
• Batch tuning of DML statements, stored routines, entire SQL files
• Hint injection
• SQL rewrites
• Visual SQL Tuning (VST) diagrams
• Advanced index analysis with recommendations
• Robust reporting with execution statistics, profiling details, predicate analysis and explain plans
• SQL stress testing
• SQL IDE with code assist, error checking, debugging and real-time quick fixes

Embarcadero® DB Optimizer™ XE is a heterogeneous tool that maximizes database and application performance by quickly discovering, diagnosing, and optimizing poor-performing SQL. DB Optimizer XE empowers DBAs and developers to:

• Eliminate performance bottlenecks by visually profiling key metrics inside the database (CPU, I/O, wait times)
• Relate resource utilization to specific queries, and helping to visually tune problematic SQL.
• Eliminate performance bottlenecks in production databases and applications
• Develop, test, profile, and tune SQL performance with a single, easy-to-use IDE across all databases

The XE family of products offer unique benefits at the most competitive price that you simply won't find in any other solution:

• True heterogeneous tool supporting all DBMSes from a single interface included in one product, one price, one license
• Run tools without installing locally; avoid conflicts when running multiple versions with Embarcadero® InstantOn™
• Centralized license management and tool deployment with Embarcadero® ToolCloud™

The new DB Optimizer XE Enterprise edition includes DB Performance Center XE. It is an advanced 24x7 monitoring option that leverages an agentless architecture, and includes customized alert thresholds, notifications, and escalations , as well as providing a unified view of the ‘database health index’ across both single and heterogeneous database environments. See all DB Optimizer XE editions.

Feature Highlights

Visual SQL Tuning (VST) Diagrams – Taking SQL tuning beyond hints and SQL rewrites with new features for faster and more advanced tuning and analysis. New in DB Optimizer XE with enhanced statistics.

• Visual SQL Tuning (VST) diagrams
• Color-coded Index Analysis

SQL Profiling, Tuning and Editing - Quickly pinpoint poor-performing SQL code and optimize using a single, easy to use IDE

• Wait-time analysis
• Continuous profiling
• Hint injection
• SQL rewrites

SQL Stress Testing –The Load Editor stress tests SQL code to ensure performance gains are realized

• Simulate parallel users
• Measure over a set period of time or execution cycles

Revision Information:

• Current Version: XE
• Prior Version: 2.0.1
• Current Release: May 2010