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.

Embarcadero® DB Optimizer™

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.

Customer Quotes

Running our company monthly invoices were taking upwards of three hours to run and sometimes the SQL server would stop processing the invoices. We needed to find out what was causing the slow down as fast as possible and fix it. DB Optimizer allowed us to see that the indexes were not optimized, memory was being squeezed and the I/O subsystem was not the best fit. This allowed our team to tackle the three major issues all at the same time without going down a wrong path. Without DB Optimizer we would have had to use numerous tools and then correlate the data to find what were the issues causing the slowdown which would have taken many man-hours to do. It is nice to have all these abilities in one package to save us time and money
- Scott Moon, Word & Brown

The golden rule with SQL is quality in equals quality out, so there's nothing worse than sending poor SQL code to production and having it negatively affect database or application performance. When using DB Optimizer, we've found that it helps us pinpoint data-intensive or frequently executed queries and optimize any problematic statements, thus improving the overall performance of our application
- Thorsten Raab, Principal, Blue Harbors

It has already helped me tremendously in addressing some of our DB2 performance issues. It also provides a great platform for working with the developers to discuss processing issues that the DBAs see in a given processing window.
- Larry Eymann, Cabelas

Database Tools | Developer Tools