DB Optimizer Professional

First year full support and upgrades will be added during checkout. This is mandatory only the first year.

Embarcadero DB Optimizer XE Pro is a heterogeneous tool that maximizes database and application performance by quickly discovering, diagnosing, monitoring and optimizing poor-performing SQL. DB Optimizer XE 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. Includes the 24x7 monitoring client, which requires DB Optimizer XE Enterprise. This products comes complete with support for all major database platforms and centralized license management and tool provisioning with "zero-install" deployment capability

Key Features:

 

• Graphical visualization of wait-time analysis
• Continuous profiling
• Batch tuning of DML statements, stored routines, entire SQL files
• Hint injection
• SQL rewrites
• Visual SQL Tuning (VST) diagrams
• Advanced index analysis with recommendations
• Robust reporting with execution statistics, profiling details, predicate analysis and explain plans
• SQL stress testing
• SQL IDE with code assist, error checking, debugging and real-time quick fixes

DB Optimizer supports SQL execution and SQL tuning on the following DBMS versions running on Linux® - and Windows NT® - based servers:

• Oracle® 8i - 11g
• Sybase® 12.5 - 15.0
• IBM® DB2® for LUW 8.0 - 9.5
• Microsoft SQL Server 2000, 2005, and 2008
• JDBC (execution only)

DB Optimizer supports SQL profiling on the following DBMS versions running on Linux® - and Windows NT® - based servers:

• Oracle® 8i - 11g
• Sybase® 12.5.0.3 - 15.0.3
• IBM® DB2® for LUW 8.2 - 9.5
• Microsoft SQL Server 2000 SP3, 2005, and 2008

System Requirements:

32 and 64-bit versions of Microsoft Windows 2003, XP, Vista and Windows 7
Red Hat Enterprise Linux 5.0 (32 bit), or SUSE Linux Enterprise Server 10 (32 bit)
Sun Java 2 Standard Edition 5.0 Update 11 for Microsoft Windows or Linux: Sun Java 2 Standard Edition 5.0 Update 11 for Linux x86
1024 MB memory
500 MB disk space

Fact sheet (PDF)

Download demo