Announcement in Brief
DB Optimizer 2.0 takes SQL tuning beyond standard hint injections and SQL rewrites and offers innovative, new features for faster and more advanced SQL tuning and analysis. New graphical tools like the Index Analysis feature let DBAs and developers fully examine SQL execution paths to better understand which indexes are used, not used, or missing. If an index is missing, DB Optimizer will offer indexing recommendations for optimum performance. The Visual SQL Tuning (VST) diagram displays indexes and constraints on tables and views, as well as the joins used in a SQL statement. This innovative visual format quickly reveals opportunities to tune the SQL or schema and enhance overall database performance. Also new is DB Optimizer’s SQL stress testing capabilities. The Load Editor stress tests the tuned SQL code to ensure performance gains are realized. DB Optimizer 2.0 is available worldwide beginning October 20th, 2009. Read the Press Release
|
Product Messaging
Embarcadero DB Optimizer maximizes database and application performance by enabling DBAs and developers to quickly discover, diagnose, and optimize poor-performing SQL. DB Optimizer eliminates existing 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. As an agentless desktop tool, DB Optimizer 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 snapshots can be saved and shared between developers, QA, and DBAs for focused diagnosis and increased productivity.
What’s New in DB Optimizer 2.0
- SQL Visual Tuning (VST) Diagrams - The Visual SQL Tuning (VST) diagram, which can be displayed in either Summary Mode or Detail Mode, 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.
- Index Analysis - The color-coded Index Analysis feature let DBAs and developers fully examine SQL execution paths to better understand which indexes are used (green), not used (blue), or missing (orange). If an index is missing, DB Optimizer will offer indexing recommendations for optimum performance.
- Load Editor - SQL stress testing simulates a number of parallel users and executions over a specific period of time or execution cycle
- Profiling Session 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.
Watch the new feature demonstration video with Greg Nerpouni!
Key Features
- Graphical visualization of wait-time analysis
- Continuous profiling
- Batch tuning of DML statements, stored routines, entire SQL files
- Hint injection
- SQL rewrites
- Visual SQL Tuning (VST) diagrams
- Advanced index analysis with recommendations
- Robust reporting with execution statistics, profiling details, predicate analysis and explain plans
- SQL stress testing
- SQL IDE with code assist, error checking, debugging and real-time quick fixes
- Supports IBM DB2 for LUW, Oracle, SQL Server, and Sybase ASE from a single interface
Pricing Information
There are no pricing or packaging changes with this release. For complete pricing information, please consult the Price List for your region.
Announcement / Rollout Activities & Timeline
Please refer to the November edition of the new Marketing Newsletter for upcoming marketing initiatives for DB Optimizer as well as the rest of the database tools in Q4!
|
