SQL profiling and tuning IDE

Embarcadero DB Optimizer maximizes database and application performance by enabling DBAs and developers to quickly discover, diagnose, and optimize poor-performing SQL.

DB Optimizer XE3

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

  • Optimize 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

Production DBAs are tasked with maximizing database performance and availability. A key concern is meeting Service Level Agreements (SLAs.) DB Optimizer helps production DBAs quickly profile Oracle®, Microsoft® SQL, Sybase®, and DB2® LUW databases to easily identify and correct the SQL causing performance bottlenecks. Key features in DB Optimizer XE3 include:

  • Ability to stream profiling data into a central repository
  • Determine resource usage for stored procedures with visibility into underlying SQL usage for SQL Server and Sybase
  • Visual SQL tuning diagram displaying indexes and constraints, now enhanced with table statistics
DB Optimizer XE DeveloperDB Optimizer XE ProDB Optimizer Professional
Support for all database platforms included Optional
Embarcadero AppWave Optional
InstantOn Optional
Centralized license management Optional
DB Optimizer 2.X core
SQL Profiling
Load Testing
SQL Editor
Tuning:
-Visual SQL Tuning
-SQL Hint Analysis
Profiling into Repository (single data source)

Key Features:

  • Single interface for all major DBMSs
  • Graphical visualization of wait-time analysis
  • Continuous profiling
  • Batch tuning of DML statements, stored routines, entire SQL files
  • Hint injection
  • SQL rewrites
  • Robust diagnostics with execution statistics, profiling details, predicate analysis and explain plans
  • SQL IDE with code assist, error checking, debugging, and real-time quick fixes
  • Color-coded Index Analysis indicating index usage
  • SQL stress testing

Revision Information:

  • Current Version: XE3/3.5
  • Prior Version: XE2/3.0
  • Current Release: May 2012