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™ XE2 is a heterogeneous tool that maximizes database and application performance by quickly discovering, diagnosing, and optimizing poor-performing SQL. DB Optimizer XE2 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™

For advanced 24x7 monitoring that leverages an agentless architecture visit DB Performance Center XE.  DB Performance Center XE includes customized alert thresholds, notifications, and escalations, was well as providing a unified view of the 'database health index' across both single and heterogeneous database environments.

See all DB Optimizer XE2 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
• Profiling reporting

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: XE2/3.0
• Prior Version: XE/2.6
• Current Release: June 2010