SQL Tuning & Analysis | DB Optimizer 2.0

By: Michael Findling

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

DB Optimizer goes beyond hint injections and SQL rewrites to offer innovative features for faster and more advanced SQL tuning and analysis. Embarcadero® DB Optimizer is a SQL profiling and tuning IDE that enables DBAs and developers to quickly discover, diagnose, and optimize poor-performing SQL.

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

Server Response from: ETNASC03