DB Optimizer
AUTOMATED SQL PROFILING AND TUNING FOR OPTIMIZED CODE PERFORMANCEDB Optimizer™ is an automated SQL optimization tool that maximizes database and application performance by
quickly discovering, diagnosing, and optimizing poor-performing SQL code. DB Optimizer empowers DBAs and databasedevelopers to eliminate performance bottlenecks by graphically profiling key metrics inside the database, relating
resource utilization to specific queries, and helping to visually tune problematic SQL.

WHY DB OPTIMIZER?

BENEFITS

Today’s database professional is short on time when it comes to performancetuning and maintaining database availability. Both DBAs and databasedevelopers face similar challenges as they are continuously asked to do more

IDENTIFY PERFORMANCE BOTTLENECKS IMMEDIATELY
Database profiling provides a graphical visualization of wait-time
analysis, making the SQL that is causing poor database performanceeasy 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 SQL execution and performance costs.
Reports share information captured during the profiling process.

with a growing database infrastructure.
The result is that only short-term and immediate tasks are completed while
long-term sustainable solutions are missed, leading to inevitable performance
problems in production databases. The business impact varies by industry ascompanies lose up to millions of dollars for each hour a key database is notavailable. These database professionals face three distinct challenges:•• Quickly understanding and identifying performance bottlenecks• Resolving performance problems with sustainable solutions
DB Optimizer is a SQL optimization tool that maximizes database andapplication performance by quickly discovering, diagnosing, and optimizing
poor-performing SQL. These capabilities allow DBAs and developers toreduce costs by maximizing productivity and IT infrastructure, improve
productivity quickly through ease of use and a consistent interface, andconnect their organization with reporting capabilities. Whether or not you
are a performance tuning specialist, DB Optimizer enables you to tune
like a pro!

TUNE SQL LIKE A PRO The SQL tuning wizard automatically suggests
solutions and provides essential context in tuning SQL code. Colorcoded Index Analysis shows used, not used, or missing indexes andused to generate all possible cases and to find the best alternative to agiven 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 using thesediagrams instead of more complex execution plans. The VST diagram
displays the tables and views used in the queries, as well as therelationships defined in those queries.
SIMULATE PRODUCTION ENVIRONMENTS Load testing verifies
performance of existing and alternative SQL queries against thedatabase. Configure queries to run multiple times in parallel and see how
they respond to your simulated production environment without the riskof actually testing in production.
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 andcomplying with Data Governance performance and availability standards.

Start for FREE!

I DE R A.com

The AWR reports from the native Oracle tools didn’t lead us to the cause of the problem,
because they weren’t detailed enough. DB Optimizer allowed us to pinpoint the culprit as the eviction
occurred. Without it, we would never have been able to catch — or fix— the problem.
Karen Morton, Oracle ACE

PRODUCT HIGHLIGHTSSQL PROFILING• Identify previously undetected performance issues

SAMPLING Identify and diagnose performance bottlenecks and problematic SQL
without agents or placing a significant load on the target database.

• Accelerate SQL tuning and optimization

LOAD EDITOR SQL stress testing simulates a number of parallel users andexecutions over a specific period of time or execution cycle.

• Visually understand complex SQL queries• Maintain database uptime and availability

CONTINUOUS PROFILING Continuously profile an entire data source within aconfigurable span of time.

• Align with data governance principlesPROFILING A STORED ROUTINE When fine tuning or testing SQL, profile theexecution of a single stored routine when profiling an entire data source is notdesired.

GENERAL FEATURES
MULTI-PLATFORM SUPPORT Manage all major DBMSs from a single interface.
Ability to use the tools on all supported platforms from a single license.
REPOSITORY CAPTURE Stream profiling data into a central repository foryour open session.
FILE CAPTURE Save an entire profiling session to a file for future analysis andreference or to share with others.
UNICODELIVE 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 sharedacross multiple workspaces and machines for collaboration purposes.

SQL TUNING
TUNING JOB Create and run tuning jobs for a single statement or batch of statements.

COMMAND-LINE API Launch profiling and tuning sessions remotely.

BATCH TUNING Tune all DML statements, stored routines, and entire SQL files.
CASE GENERATION SQL rewrites and hint injection are used to generate allpossible cases and find the best alternative to a given SQL statement.

VISUAL DIAGNOSTICS
PROFILE CHART Shows the CPU, I/O, and other wait activity over thecourse of the session.
EXECUTION STATISTICS Detailed information on the profiled SQL and wait
categories, broken down by SQL statements, events, and sessions.
PROFILING DETAILS Drill down into the execution details for any given statement,
including the SQL text, events, sessions, child cursors, blockers, procedures,and SQL details.
PREDICATE ANALYSIS SQL statements are rolled up for a true analysis of thenumber of executions in real-time.
EXPLAIN PLANS The Explain Plan for each SQL statement can be computed ondemand via a context menu item in the Execution Statistics table. The Explain Planappears in a separate view as a tree with columns and collapsible column groups.
CROPPING Highlights a time interval in the profile chart to instantly change thedata displayed, making it easier to see the details.

SQL REWRITES SQL rewrites are suggested as part of the case generation in theSQL tuner. SQL rewrites are also suggested as you type in the SQL IDE.
HINT INJECTION Customize the subset of hints to be considered for hint injection
and alternative execution paths.
COST GENERATION Display 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 turns text-based
SQL code into graphical SQL diagrams that display the tables and views used in thequeries, as well as the relationships defined in those queries.
INDEX ANALYSIS The color-coded Index Analysis feature shows indexes that arefor 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

877 GO IDERA 464 3372

EMEA +44 1628 684 400

TWITTER twitter.com/Idera_Software

APAC +61 1300 307 211

FACEBOOK facebook.com/IderaSoftware

MEXICO +52 (55) 8421-7980

LINKEDIN linkedin.com/company/idera-software

BRAZIL +55 (11) 3280-1159