Embarcadero DB Optimizer XE2

New Features

What's new in DB Optimizer XE2?

Enhanced SQL Visual Tuning (VST) Diagrams

Visual SQL Tuning (VST) diagrams have been enhanced to include table statistics. The VST diagram now can display table sizes, the sizes of the joins between tables in the query, and the percentage of rows returned, on every table that has a predicate filter. These statistics allow the developer to immediately see any bottlenecks or potential issues as well as to give a good indication as to the best execution plan for the query.

Profiling Repository

Stream profiling data into a central repository, for future reference or collaboration.

Stored Procedure Insight

When profiling stored procedures, you can now see the workload incurred by the procedure, and also drill inside the procedure to view the resource usage for specific SQL statements (SQL Server and Sybase).

Features

SQL Profiling

• Graphical visualisation of wait-time analysis to easily pinpoint the SQL causing poor database performance
• Continuous profiling monitors an entire datasource within a configurable span of time
• Explain plans for a better understanding of how SQL will be executed and the performance costs
• All data and metadata pertaining to a profile session can be saved as a single entity into an archive file so profiles can be shared.
• Stream profiling data into central repository
• Reporting to allow sharing of information captured during the profiling process.

SQL Tuning

• Batch tuning of DML statements, stored routines, and entire SQL files
• Case Generation is used to generate all possible cases and find the best alternative to a given SQL statement including SQL rewrites and hint injection
• The Visual SQL Tuning (VST) diagram displays indexes and constraints on tables and views with table statistics, as well as the joins used in a SQL statement such as Cartesian joins, implied Cartesian joins and many-to-many relationships.
• The color-coded Index Analysis feature shows indexes that are used (green), not used (blue), or missing (orange) and offers indexing recommendations for optimum performance.

Visual Diagnostics

• Profile chart shows the CPU, I/O, and other wait activity over the course of the profile session
• Execution statistics provide detailed information about the profiled SQL and wait categories
• Explain plans for each SQL statement can be computed on demand in the Execution Statistics table
• Stored procedure insights.

SQL Editing

• Includes a powerful SQL IDE geared to the needs of application developers
• Real-time quick fixes flag and correct inefficient SQL automatically
• SQL code assist and real-time SQL syntax validation
• Project-level SQL file cataloging and search features.

General

• Full support for DB2 for LUW, Oracle, SQL Server and Sybase ASE.
• Full Unicode support
• Command line interface.

Editions

DB Optimizer XE2 Developer

• Support for all database platforms
• Embarcadero AppWave
• InstantOn
• Centralised licence management
• DB Optimizer 2.x core
• SQL profiling
• Load testing
• SQL editor.

DB Optimizer XE2 Pro

Includes all the features of the Developer edition, plus:

• Tuning - visual SQL tuning and SQL hint analysis
• Profiling into repository (single data source).

System Req.

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