DB Optimizer Developer

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

Embarcadero DB Optimizer XE Developer is a heterogeneous tool that maximizes database and application performance by quickly discovering, diagnosing, and graphically rendering poor-performing SQL in a way that can be shared between development, database administrators, QA and management. It empowers DBAs and developers to identify and discuss performance bottlenecks by visually profiling key metrics inside the database (CPU, I/O, wait times), relating resource utilization to specific queries, as well as graphically rendering problematic SQL. Includes support for all major database platforms from a single interface, 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