[All]
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.
Connect with Us