DB Optimizer

Automate SQL Tuning and Profilin

DB Optimizer

  • Streamline tuning of SQL code on major DBMSs from one interface
  • Tune SQL like a pro with automated performance optimization suggestions
  • Tackle complex SQL queries with visual SQL tuning diagrams
  • Pinpoint problem SQL with database profiling of wait-time analysis
  • Load test alternative SQL queries in simulated production environment

פרולוג'יק היא המפיצה הרישמית של מוצרי IDERA בישראל.
כמו כן פרולוג'יק מספקת חבילת מוצר מושלמת הכוללת אינטגרציה, ליווי והדרכה.

dbo_tuning_analysis

Streamline SQL Tuning Across Major DBMSs

Tune poorly performing SQL code on all major DBMSs (Oracle, SQL Server, DB2 and SAP Sybase) from a single common interface. Reduce training requirements and streamline collaboration among teams across the organization.

Tune SQL Like a Pro!

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 recommenda­tions for optimum performance. Case Generation is used to generate all possible cases and to find 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 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.

Identify Performance Bottlenecks Immediately

Database profiling provides a graphical visualization of wait-time anal­ysis, making the SQL that is causing poor database performance easy to pinpoint. Continuous profiling monitors an entire data source within a configurable span of time. Also, 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.

Simulate Production Environments

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.

Tuning Jobs

Create and run tuning jobs for a single statement or batch of statements. Tune all DML statements, stored routines and entire SQL files.

SQL Rewrites & Case Generation

SQL rewrites are suggested as part of the case generation in the SQL tuner as well as when you type in the SQL IDE. SQL rewrites and hint injection are used to generate all possible cases and find the best alternative to a given SQL statement.

Hint Injection

Customize the subset of hints to be considered for hint injection and alternative execution paths.

Explain Plan Cost

View the explain plan cost for each original statement and each generated case to give the user the expected cost given the execution path utilized 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 difference viewer helps the user spot the textual differences between any two SQL statements.

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.

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.

Repository Capture

Stream profiling data into a central repository for your open session.

File Capture

Save an entire profiling session to a file for future analysis and reference or to share with other teams in the organization.

Command Line API

Launch profiling and tuning sessions remotely.

Unicode Support

Full Unicode character support throughout the application.

Minimum Hardware Requirements:

  • 1 GHz or faster processor
  • 1 GB of RAM
  • 1 GB of free disk space
  • 1024 x 768 display

Supported Operating Systems:

  • Windows 10, Windows 8.1, Windows 8, Windows 7 (32- and 64-bit)
  • Windows Server 2012 & 2012 R2, Windows Server 2008 SP1 & 2008 R2 (32- and 64-bit)
  • Linux, x86-32, GTK 2
    – Red Hat Enterprise Linux 5.0
    – SuSe Linux Enterprise Server 10

Supported Database Platforms:

  • SQL Execution:
    • Oracle 9i, 10g, 11g, 12c
    • SAP Sybase ASE 12.x-15.x
    • IBM DB2 LUW 9-10.x and 11.x*
    • Microsoft SQL Server 2005, 2008, 2012*, 2014*, 2016*
    • JDBC (execution only)
  • SQL Profiling:
    • Oracle 9i, 10g, 11g, 12c
    • SAP Sybase ASE 12.x-15.x
    • IBM DB2 LUW 9-10.x and 11.x*
    • Microsoft SQL Server 2005, 2008, 2012*, 2014*, 2016*

*For these databases, DB Optimizer supports a subset of this database version’s features/functions.
Note: DB Optimizer does not access the information, tables or views licensed under Oracle's diagnostic pack.