What is DB Optimizer XE3?
Embarcadero® DB Optimizer™ XE3 is a heterogeneous tool that maximizes database and application performance by quickly discovering, diagnosing, and optimizing poor-performing SQL. DB Optimizer XE3 empowers DBAs and developers to eliminate performance bottlenecks by visually profiling key metrics inside the database (CPU, I/O, wait times), relating resource utilization to specific queries, and helping to visually tune problematic SQL.
Benefits and Insights
Why use DB Optimizer XE3?
Key differentiators & advantages of DB Optimizer XE3
- 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- Ability to stream profiling data into a central repository
- Determine resource usage for stored procedures with visibility into underlying SQL usage for SQL Server and Sybase
- Visual SQL tuning diagramdisplaying indexes andconstraints, now enhanced with table statistics
- AppWave™ is an enterprisegradeprivate PC app store thatprovides a mobile-likeapp experience for PC software applications, so you can quickly discover and run PC apps including DB Optimizer