Welcome to Embarcadero® DB Optimizer™ 2.5
Published May 19, 2010
DB Optimizer Home |
DB Optimizer Documentation | Embarcadero Technical Support | www.embarcadero.com
Thank you for using Embarcadero DB Optimizer, an enterprise SQL development and optimization tool
that gives database developers and administrators the perfect environment for building the best performing
SQL code. This application easily identifies inefficient SQL code and boosts developer productivity
by ensuring SQL is right before it becomes a problem in mission-critical applications. DB Optimizer also provides
a rich SQL IDE with code completion, real-time error checking, code formatting and sophisticated object
validation tools. Lastly, DB Optimizer provides advanced project and
data source management tools.
DB Optimizer is supported on the following operating systems:
- Microsoft Windows XP, x86-32, Win32
- Microsoft Windows Vista, x86-32, Win32
- Microsoft Windows 2003
- Linux, x86-32, GTK 2
- Red Hat Enterprise Linux 5.0
- SuSe Linux Enterprise Server 10
DB Optimizer will require a Java5 VM to run:
- Windows XP/Vista/2003 Sun Java 2 Standard Edition 5.0 Update 11 for Microsoft Windows
- Linux: Sun Java 2 Standard Edition 5.0 Update 11 for Linux x86
SQL execution and SQL tuning with DB Optimizer is supported on the following DBMS platforms and versions:
- Oracle (8i - 11g)
- Sybase (12.5 - 15.0)
- IBM DB2 for LUW (8.0 - 9.5)
- MS SQL Server (2000, 2005, 2008)
- JDBC (execution only)
SQL profiling with DB Optimizer is supported on the following DBMS platforms and versions:
- Oracle (8i - 11g)
- Sybase (12.5.0.3 - 15.0.3)
- IBM DB2 for LUW (8.2 - 9.5)
- MS SQL Server (2000 SP3, 2005, 2008)
DB Optimizer should be installed in a different directory than previous versions of DB Optimizer 1.0. If DB Optimizer is installed in the same directory, the following error will result in at application start up: “Unable to read workbench state. Workbench UI layout will be reset.”
Additionally, DB Optimizer should be installed in a different directory than previous versions. If a previous version is already installed on your machine, either change the default Workspace or delete all files from the Workspace directory. The Workspace directory location appears whenever you start Optimizer, and can be redefined from this dialog box. If the same Workspace is indicated for the new version as was indicated previously, the following error will result: “Cannot restore workbench layout”.
If DB/Optimizer is already running, you can also modify the Workspace directory by choosing File > Switch Workspace > Other from the Main Menu.
What's New in DB Optimizer 2.5
Improvements to Profiling
Improvements to Tuning
What's New in DB Optimizer 2.0
Visual SQL Tuning Diagram
Index Analysis
Expanding Views in the VST Diagram
Profile Details
Licensing
Release Notes
DBMS Support
Important Advisory Notes
Bug Fixes
What's New in DB Optimizer 2.5
Improvements to Profiling
- New Procedures tab for SQL Server and Sybase platforms enables you to examine procedures and their effect on database efficiency.
- Top SQL tab now provides average execution time and average wait time statistics.
- Improved SQL text collection by querying the database cache more often and more intelligently thereby reducing the occurrences of UNKNOWN statements.
- Max CPU and Max Engine count can now be specified for cases when the database platform does not report how many CPUs or engines are available and for when you want to see the performance gain or hit created by increasing or decreasing the number of CPUs or engines.
- New Profiling Repository available for Oracle platforms offers the ability to gather and store more profiling information that is then readily available for analysis from the Data Source Explorer.
- Performance optimization enables the Profiler to better support longer sessions and more heavily loaded servers.
Improvements to Tuning
- New transformations or query rewrites available for Oracle data sources offer more tuning alternatives.
- Extended support for statements with bind variables on SQL Server and Sybase.
- Filter ratios, and table size and table join size optionally added to Visual SQL Tuning diagrams. Collecting this data may be time-consuming for large databases.
- All data from a tuning session is now saved, allowing for more effective sharing of data between users.
>
What's New in DB Optimizer 2.0
Embarcadero DB Optimizer simplifies optimization and development for application
developers with many features for improving productivity and reducing code errors. DB Optimizer features
fall into two general categories:
- Profiling and tuning components that let you locate and diagnose problem queries
- A rich SQL IDE with code completion, real-time error checking, code formatting, and sophisticated object validation tools helps streamline coding tasks.
The DB Optimizer user interface offers easy to use analysis tools and improves overall productivity. DB
Optimizer offers native support for IBM® DB2® for LUW, Oracle®, Microsoft® SQL Server and Sybase® as
well as JDBC support for other DBMS.
Visual SQL Tuning Diagram
- Visual SQL Tuning diagram that lets both developers and DBAs quickly analyze indexes and constraints on tables and views and understands joins used in a SQL statement.
Index Analysis
- Color-coded Index Analysis feature displays all indexes in the execution plan with vital information such as which indexes are maximizing performance, suggests missing indexes, and indicates which indexes are used by the execution plan and which are not.
Expanding Views in the VST Diagram
- View and sub-views can now be expanded to show the contents within them, including the tables and the indexes on those tables. Views can now be expanded in both Project Explorer and the Visual SQL Tuning diagram.
Profile Details
- Profiling Details of the SQL Profiler have been expanded to show Session Details for Sybase and SQL Server, and the SQL that ran in the selected session for Sybase, SQL Server, and DB2.
Licensing
- Platform licenses are now checked out on demand, based on connected platforms.
Release Notes
DBMS Support
- Generic JDBC
- IBM DB2 LUW 8.0 - 9.0
- Microsoft SQL Server 2000 and 2005
- Oracle 8i - 11g
- Sybase 12.5 - 15.0
Important Advisory Notes
- Saved profiling and tuning session files (.oar) created using previous
versions of DB Optimizer are not compatible with DB Optimizer XE and
DB Optimizer 2.5. You can however have more than one version of DB Optimizer
installed on the same system. To read old .oar files, run the older version of DB Optimizer.
- On Microsoft SQL Server 2000, the Profiling feature is only supported if Service Pack 3 (SP3) is installed.
- Minimum hardware requirements: Pentium 4-level processor, 1024 MB of memory, 500 MB of disk space, 1024 x 768 screen resolution
- Supported operating systems: Microsoft Windows XP (32-bit), Microsoft Windows Vista (32-bit), or Microsoft Windows Server 2003 (32-bit)
Bug Fixes
Use your browser Find feature to locate a particular bug number or click a link below to see the issues addressed in a specific build.
Bugs Fixed in DB Optimizer 2.5
Bugs Fixed in DB Optimizer 2.0.1
Bugs Fixed in DB Optimizer 2.0
| Bugs Fixed in Embarcadero DB Optimizer 2.5 |
| OPT-1236
| DB Optimizer no longer errors on Vista when completing the bind variable and collapsing the SQL Text.
|
|
| OPT-2038
| Discover data sources now finds any SQL Server data source on the network.
|
|
| OPT-2148
| The system is now more reliable when automatically detecting connections previously defined.
|
|
| OPT-2244
| The system no longer creates false cartesian joins on the Visual SQL Tuning diagram for nested select statements.
|
|
| OPT-2265
| The system now usess the right Oracle schema when tuning from profiler.
|
|
| OPT-2309
| The on-demand cache is now working correctly in all schema configurations of the Oracle E-Business Suite.
|
|
| OPT-2396
| The system no longer errors when running or profiling a stored procedure with user-defined datatype parameters.
|
|
| Bugs Fixed in Embarcadero DB Optimizer 2.0.1 |
| OPT-1784
|
When using All-Access, Database platform licenses are now correctly checked out upon launch of the Eclipse-based version of DB Optimizer.
|
|
| OPT-1940
|
Tuning can now be initiated from the command line.
|
|
| OPT-1987
|
On Sybase indexes are now suggested for statements where the schema is not specified.
|
|
| OPT-2001
| The analysis and the EXPLAIN PLAN for generated cases now correctly works with the SYBASE cp936 character set.
|
|
| OPT-2045
|
Profiling can now be initiated from the command line.
|
|
| Bugs Fixed in Embarcadero DB Optimizer 2.0 |
| OPT-1622
|
From the command line the profiling duration can now be increased to more than 60 seconds.
|
|
| OPT-1675
|
The Tuner can now properly extract SQL from Procedures (Sybase).
|
|
Additional Resources
Licensing Your Embarcadero Technologies Product
All Embarcadero Technologies products include a 14-day
trial period. To continue using the product without interruption, we
recommend that you license it as soon as possible. To license your
product, use the License Request Wizard found in the Help menu of your respective product. If you have not yet purchased your Embarcadero Technologies product, contact [email protected], or [email protected] for sales in the EMEA region.
Embarcadero Technologies Product Support
The Embarcadero Technologies Web site is an excellent
source for additional product information, including white papers,
articles, FAQs, discussion groups, and the Embarcadero KnowledgeBase.
Go to www.embarcadero.com/resources, or click any of the links below, to find:
Embarcadero Technologies Technical Support
If you have a valid maintenance contract with
Embarcadero Technologies, the Embarcadero Technical Support team is
available to assist you with any problems you have with our
applications. Our maintenance contract also entitles registered users
of Embarcadero Technologies products to download free software upgrades
during the active contract period. Evaluators receive free technical
support for the term of their evaluation (14 days).
We encourage you to open technical support cases via the Technical Support request form at the Embarcadero Technologies Web site. For additional information about Embarcadero Technologies Technical Support, go to the Support page on our Web site.
Embarcadero Technologies on the Web
To download evaluations of other Embarcadero
Technologies products or to learn more about our company and our
products visit us at www.embarcadero.com.