Database Monitoring Tools | DB Optimizer

Embarcadero DB Optimizer helps to maximize database performance. This SQL profiling tool lets you quickly discover, diagnose, and optimize poor-performing SQL. By discovering data-intensive or frequently executed queries, focusing in on specific SQL statements through query statistics (i.e., CPU, I/O, wait times), and optimizing any problematic statements, DB Optimizer helps you to eliminate performance bottlenecks.

DB Optimizer offers:

• Graphical visualization of wait-time analysis to easily pinpoint the SQL causing poor database performance
• Hyperlinked drill-downs for locating detailed activity information for an individual SQL statement
• Explain plans for a better understanding of how SQL will be executed and the performance costs
• Real-time Quick Fixes to flag and correct inefficient SQL automatically (Oracle)
• Batch tuning of DML statements, stored routines, entire SQL files and the System Global Area (Oracle)

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.

Related Products

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