Embarcadero® DB Optimizer™ XE2 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. DB Optimizer XE2 Developer 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, and helping to visually tune problematic SQL. DB Optimizer XE2 Developer includes Visual SQL Tuning (VST) diagrams of problematic statements. The VST diagram displays indexes and constraints on tables and views, as well as the joins used in a SQL statement, revealing opportunities to tune the SQL or schema and enhance overall database performance.

DB Optimizer XE Developer includes AppWave which provides a mobile-like experience for Windows desktop applications. With AppWave, you can quickly discover and immediately run PC apps without the hassles of desktop installs, manual upgrade processes, or manual license tracking.

DB Optimizer XE2 Developer is easy to install and point at any database to quickly detect problematic SQL statements. Continuous profiling monitors performance within a configurable span of time to help verify the effects of tuned statements. Profiling data can be streamed into a central repository and snapshots can be saved and shared between developers, QA, and DBAs for focused diagnosis and increased productivity. DB Optimizer XE2 Developer comes complete with support for all major databases including IBM® DB2® for LUW, Microsoft® SQL Server, Oracle®, and Sybase®.

Price above includes Embarcadero DB Optimizer XE2 Maintenance, which is required to be purchased on the first year.

DB Optimizer XE2 Maintenance entitles customers to:

• Unlimited technical support
• All product upgrades
• Closed beta programs
• Product answer books

This product comes complete with support for the following DBMS versions:

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

DB Optimizer XE2 Developer can even determine resource usage for stored procedures with visibility into underlying SQL usage for SQL Server and Sybase.

This product provides a workstation license for a single user. Not sure if DB Optimizer XE2 Developer is right for you? Then check out the DB Optimizer XE2 product page or contact sales at Embarcadero Technologies.

System Requirements

• Microsoft Windows 2003, XP, Vista (32 bit), 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

File size: 167 MB