Embarcadero DB Optimizer XE4

General features

• Multi-platform support - supports all major DBMSs from a single interface. Ability to use the tools on all supported platforms from a single license.
• Embarcadero AppWave - enables centralised license management and tool deployment.
• Unicode - offers full Unicode support.
• Command-line API - launch profiling and tuning sessions remotely.

Visual diagnostics

• Profile chart - shows the CPU, I/O, and other wait activity over the course of the session. Zoom in/out functionality available. (Wait categories vary by platform.)
• Execution statistics - detailed information on the profiled SQL and wait categories, broken down by SQL statements, events, and sessions.
• Profiling details - drill down into the execution details for any given statement, including the SQL text, events, sessions, child cursors, blockers, procedures, and SQL details.
• Predicate analysis - SQL statements are rolled up for a true analysis of the number of executions in real-time
• Explain plans - the Explain Plan for each SQL statement can be computed on demand via a context menu item in the Execution Statistics table. The Explain Plan appears in a separate view as a tree with columns and collapsible column groups.
• Cropping - highlights a time interval in the profile chart to instantly change the data displayed, making it easier to see the details.

Profiling

• Sampling - identify and diagnose performance bottlenecks and problematic SQL without agents or placing a significant load on the target database.
• Load editor - SQL stress testing simulates a number of parallel users and executions over a specific period of time or execution cycle.
• Continuous profiling - continuously profile an entire data source within a configurable span of time.
• Profiling a stored routine - when fine tuning or testing SQL, profile the execution of a single stored routine when profiling an entire data source is not desired.
• Live data - show data in real-time while profiling is in progress.
• Sharing profile sessions - all data and metadata pertaining to a profile session can be saved as a single entity into an archive file. Profiles can be shared across multiple workspaces and machines for collaboration purposes.

Tuning

• Tuning job - create and run tuning jobs for a single statement or batch of statements.
• Batch tuning - tune all DML statements, stored routines and entire SQL files.
• Case generation - SQL rewrites and hint injection are used to generate all possible cases and find the best alternative to a given SQL statement.
• SQL rewrites - SQL rewrites are suggested as part of the case generation in the SQL tuner. SQL rewrites are also suggested as you type in the SQL IDE.
• Hint injection - customise the subset of hints to be considered for hint injection and alternative execution paths.
• Cost generation - display the explain plan cost for each original statement and each generated case to give the user the expected cost given the execution path utilised by the database.
• Visual SQL tuning - the Visual SQL Tuning (VST) diagram displays indexes and constraints on tables and views, as well as the joins used in a SQL statement such as Cartesian joins, implied Cartesian joins and many-to-many relationships, with table statistics.
• Index analysis - 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.
• Execution statistics - run the SQL with alternative execution paths to discover the fastest running SQL statement, and apply the change at the click of a button.
• Textual comparison of cases - a visual diff viewer helps the user spot the textual differences between any two SQL statements.

Data capture

• File capture - save an entire profiling session to a file for future analysis and reference or to share with others.
• Repository capture - stream profiling data into a central repository for your open session.