|
|
Product Details
|
|
|
 |
Embarcadero DB Optimizer XE
Published By:
Embarcadero DB Optimizer maximises database and application performance by enabling DBAs and developers to quickly discover, diagnose, and optimise poor-performing SQL. DB Optimizer eliminates performance bottlenecks by identifying data intensive or frequently executed queries, focusing on specific SQL statements through query statistics (CPU, I/O, wait times), and fine-tuning problematic statements.
- Optimise SQL performance throughout the development lifecycle
- Eliminate performance bottlenecks in production databases and applications
- Develop, test, profile, and tune SQL in a single, easy-to-use IDE
|
Product Variants
DB Optimizer XE, Developer - Licence *UK ONLY*
Variant
|
|
Manufacturer Part#
|
|
Our Part#
|
|
|
| Developer - Concurrent Licence - AppWave *Maint is Mandatory* *UK ONLY* |
|
DOSX02ELETWB9-UK |
|
661874 |
|
Quote
|
| Developer - Network Named Licence - AppWave *Maint is Mandatory* *UK ONLY* |
|
DOSX02ELELWB9-UK |
|
661873 |
|
Quote
|
| Developer - Workstation Licence - ESD *Maint is Mandatory* *UK ONLY* |
|
DOSX02ELEWWB9-UK |
|
661872 |
|
Quote
|
DB Optimizer XE, Developer - Maintenance *UK ONLY*
Variant
|
|
Manufacturer Part#
|
|
Our Part#
|
|
|
| Developer - Concurrent 1st Year Maint Only - AppWave *UK ONLY* |
|
DOSX02ELETWB9M-UK |
|
662092 |
|
Quote
|
| Developer - Network Named 1st Year Maint Only - AppWave *UK ONLY* |
|
DOSX02ELELWB9M-UK |
|
662091 |
|
Quote
|
| Developer - Workstation 1st Year Maint Only - ESD *UK ONLY* |
|
DOSX02ELEWWB9M-UK |
|
662090 |
|
Quote
|
DB Optimizer XE, Professional - Licence *UK ONLY*
Variant
|
|
Manufacturer Part#
|
|
Our Part#
|
|
|
| Professional - Concurrent Licence (includes DB Performance Center client) - AppWave *Maint is Mandatory* *UK ONLY* |
|
DOBX02ELETWB9-UK |
|
661877 |
|
Quote
|
| Professional - Network Named Licence (inc DB Per Center Client) - AppWave *Maint is Mandatory* *UK ONLY* |
|
DOBX02ELELWB9-UK |
|
661876 |
|
Quote
|
| Professional - Workstation Licence (includes DB Performance Center client) - ESD *Maint is Mandatory* *UK ONLY* |
|
DOBX02ELEWWB9-UK |
|
661875 |
|
Quote
|
DB Optimizer XE, Professional - Maintenance *UK ONLY*
Variant
|
|
Manufacturer Part#
|
|
Our Part#
|
|
|
| Professional - Concurrent 1st Year Maint Only (includes DB Performance Center client) - AppWave *UK ONLY* |
|
DOBX02ELETWB9M-UK |
|
662095 |
|
Quote
|
| Professional - Concurrent 1st Year Maint Only for Upgrade (From 2+ platform DB Optimizer) - ESD *UK ONLY* |
|
DOBX02EUETWC9M-UK |
|
662098 |
|
Quote
|
| Professional - Network Named 1st Year Maint Only (includes DB Performance Center client) - AppWave *UK ONLY* |
|
DOBX02ELELWB9M-UK |
|
662094 |
|
Quote
|
| Professional - Network Named 1st Year Maint Only for Upgrade (From 2+ platform DB Optimizer) - ESD *UK ONLY* |
|
DOBX02EUELWC9M-UK |
|
662097 |
|
Quote
|
| Professional - Workstation 1st Year Maint Only (includes DB Performance Center client) - ESD *UK ONLY* |
|
DOBX02ELEWWB9M-UK |
|
662093 |
|
Quote
|
| Professional - Workstation 1st Year Maint Only for Upgrade (From 2+ platform DB Optimizer) - ESD *UK ONLY* |
|
DOBX02EUEWWC9M-UK |
|
662096 |
|
Quote
|
DB Optimizer XE, Professional - Upgrade *UK ONLY*
Variant
|
|
Manufacturer Part#
|
|
Our Part#
|
|
|
| Professional - Concurrent Upgrade (From 2+ platform DB Optimizer) - ESD *UK ONLY* |
|
DOBX02EUETWC9-UK |
|
661880 |
|
Quote
|
| Professional - Network Named Upgrade (From 2+ platform DB Optimizer) - ESD *UK ONLY* |
|
DOBX02EUELWC9-UK |
|
661879 |
|
Quote
|
| Professional - Workstation Upgrade (From 2+ platform DB Optimizer) - ESD *UK ONLY* |
|
DOBX02EUEWWC9-UK |
|
661878 |
|
Quote
|
New Features
What's new in DB Optimizer XE?
Along with enhancements to the core product, DB Optimizer XE includes all database platforms supported in one price, one license; Embarcadero ToolCloud centralised license and deployment features; and InstantOn for running tools without installation.
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.
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
Reporting
- 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
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
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
|
|
|
|
|
|
|