Client/Server Software Benelux
Tel: +31 23 542 22 27

DB Optimizer

SQL Profiling and Tuning IDE

** Eliminate performance bottlenecks in production databases and applications
** Prevent poor-performing SQL from reaching production
** Develop, test, profile, and tune SQL in a single easy-to-use IDE

Creating Embarcadero DB Optimizer maximizes database performance by enabling developers and DBAs to quickly discover, diagnose, and optimize poor-performing SQL. DB Optimizer eliminates performance bottlenecks by discovering data intensive or frequently executed queries, focusing in on specific SQL statements through query statistics (CPU, I/O, wait times), and optimizing any problematic statements.

** Graphical visualization of wait-time analysis to easily pinpoint the SQL causing poor database performance
** Hyperlinked drill-downs for locating detailed activity information for an individual SQL statement
** Explain plans for a better understanding of how SQL will be executed and the performance costs
** Real-time Quick Fixes to flag and correct inefficient SQL automatically (Oracle)
** Batch tuning of DML statements, stored routines, entire SQL files and the System Global Area (Oracle)

Wait time analysis gives you a complete performance profile from the end-user's point of view, making it possible to truly improve overall database performance. In addition, DB Optimizer incorporates Embarcadero PowerSQL Professional Edition, making it possible to develop, test, profile, and tune SQL in one easy-to-use application.