Database profiling provides a graphical visualization of wait-time analysis, making the SQL causing poor database performance easy to pinpoint. Continuous profiling monitors an entire data source within a configurable span of time. Explain plans are provided for a better understanding of how SQL will be executed and the performance costs. Utilize reporting to allow sharing of information captured during the profiling process.
The SQL tuning wizard automatically suggests solutions and provides essential context in tuning SQL code. Color-coded Index Analysis shows used, not used, or missing indexes and offers recommendations for optimum performance. Case Generation enables database optimization by generating all possible cases and finding the best alternative to a given SQL statement by including SQL rewrites and hint injections.
Visually Tackle Complex SQL Queries
Unique in the industry, Visual SQL Tuning (VST) diagrams turn text-based SQL code into graphical SQL diagrams. This approach helps DBAs and developers understand the impact of SQL statements on the database. 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.
Load testing verifies performance of existing and alternative SQL queries against the database. Configure queries to run multiple times in parallel and see how they respond to your simulated production environment without the risk of actually testing in production. Explore Ready, Set Load Test to learn more about how load testing can affect your business.
Become Proactive in Data Governance Compliance
DB Optimizer's ability to identify bottlenecks via database profiling, tune SQL, and load test gives organizations an advantage in ensuring database optimization, uptime, and availability. This functionality gives you the ability to be proactive in identifying performance problems, and complying with Data Governance performance and availability standards.
Get to know DB Optimizer
Listed product, feature, and database platform support varies based on product edition. For details, please visit the Product Editions tab.
Minimum hardware requirements:
DB Optimizer is supported on the following operating systems:
DB Optimizer Product Editions
DB Optimizer is available in two editions – Developer and Professional, both of which have platform-specific and XE versions.
Developer Edition – Designed for the proactive Database Developer to optimize their SQL code through identification of database bottlenecks and load testing of their SQL code. Modification of SQL code can be done in the SQL IDE and with the assistance of visual SQL tuning diagrams.
Professional Edition – Designed for the performance DBA in need of identifying database bottlenecks, and fixing slow running SQL queries through DB Optimizer's SQL tuning and load testing capabilities. Also includes Advanced Profiling capabilities (Oracle only) allowing DBAs to continuously monitor database activity over a period of time.
Platform-specific Versions – These products support one major platform. DB Optimizer for Oracle, DB Optimizer for SQL Server, DB Optimizer for Sybase, and DB Optimizer for DB2 are available.
XE Version – Grants the license holder the ability to connect to multiple supported database platforms within the same User Interface, with no need to purchase additional platform-specific software. These users can connect to Oracle, SQL Server, Sybase, and DB2 (LUW) platforms simultaneously.
- FREE TRIALS
- Architecture & Modeling
- Application Development
- Database Management & Development
- Embedded Database
- All Products...
- News, Events, & Blogs
- Data Governance
- Government Solutions
- Software Licensing and Management
- Data Management
- Database Platforms
- Performance Optimization
- Application Development
- Database Performance and Management
- Vertical Markets