Embarcadero DB Optimizer maximizes database and application performance by enabling DBAs and developers to quickly discover, diagnose, and optimize 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.
- 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
DB Optimizer offers:
- Graphical visualization of wait-time analysis to easily pinpoint the SQL causing poor database performance
- Continuous profiling monitors an entire data source within a configurable span of time
- Batch tuning of DML statements, stored routines, entire SQL files
- Explain plans for a better understanding of how SQL will be executed and the performance costs
- SQL editor with real-time quick fixes to flag and correct inefficient SQL automatically
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.
Revision Information:
- Current Version: 1.5.1
- Prior Version: 1.5
- Current Release: May 2009
Related Products
- Embarcadero® J Optimizer
Comprehensive environment for optimizing application performance and managing application quality. - Embarcadero® Performance Center
24/7 database performance monitoring for maximum database availability and performance. - Rapid SQL®
Write high-performance, quality SQL in an integrated cross-platform database development environment. - DBArtisan®
The leading cross-platform database administration solution, helps DBAs maximize performance, availability, and security. - Embarcadero® Change Manager
A complete set of schema, data, and configuration tools to manage the database change management lifecycle. - Embarcadero® All-Access
Instant access to the languages, tools, and technologies to design, build, and run your software applications and database systems.







