Business Challenges

Performance Nightmares

Last Friday your databases were running like a well oiled machine- transactions were zipping along, you were outperforming your Service Level Agreements, customers were happy, and it seemed like your IT deprtament could do no wrong. Now it’s Monday morning- databases are down, the ones that aren’t should be on life support, customers are angry, phones are ringing, your top performance DBA is home with the flu, and no one knows what happened. What changed?!?!?

Change Velocity

Utilities are now running automatically.
Autonomic tuning is making automated changes to memory configurations.
Dynamic SQL still has a mind of its own and is influenced by automatic statistics and dynamic memory configurations.
XQueries add yet another dimension to dynamic optimization.

If you thought Dynamic SQL provided performance predictability challenges, multiply Automatic Utilities by Autonomic Tuning by Dynamic Optimization and prepare for a potentially new level of performance volatility and resource shortages. With so many wheels concurrently in motion, physical design problems and the consequences of dynamic changes become increasing difficult to understand and rapidly address.

Compare DB2 Tools

Compare DBI's Integrated Suite of DB2 Performance Analysis, Tuning, Trending, and Alerting tools with other tools.
>> CLICK HERE <<

IBM Information
on Demand
Showcase

Hunt SQL Performance Problems with Speed and Agility

See what's new in Release 4.2!
See what's new in Release 4.1!

Performance Problem Detection

It begins with finding the database with the lowest score or worst performance metrics. If there are multiple partitions, right click the database name to see scores and metrics compared for each partition. From the database or partitions, easily navigate through the worst performing bufferpools, tablespaces, and tables to precisely find the most costly SQL that is causing performance degradation. Click to Explain the SQL and get physical design advice. Click, done, solved!

Click to See Larger Image in a New Window

Performance Change Management

Brother-Panther® provides a major breakthrough in performance analysis and change management. Brother-Panther KNOWS what changed, when, and how changes influenced performance. Comprehensive history combined with rich analytics enable the analysis of performance trends over time correlated to change events (physical design changes, profile changes, DB & DBM configuration changes, and bufferpool changes). Armed with the knowledge of which change caused performance to head south, you will be able to easily rectify performance problems and inefficiencies. You will also find it remarkably easy to verify the effectiveness of tuning changes!

Performance Trend Graph with Configuration Changes

Click to See Larger Image in a New Window

Request a Proof of Concept (POC).

Key Features

A Database Score, like a Credit Score, is provided so that you can quickly understand a database’s health and efficiency. You no longer need to digest dozens of metrics and indicators.

Multiple databases are presented in a sorted summary grid making it a snap to know at a glance which databases require attention and which are fine.

Optimized for multiple partitions – whether logical or DPF, easily compare performance of partitions to detect load imbalance and skew.

Logical Workflows guide you through database objects with increasing filtered granularity of performance information, or jump to aggregated depth levels of your choice:

Database » Partitions » Bufferpools » Tablespaces » Tables » Cost Aggregated Statements
Database » Tables with high I/O » Statements causing high I/O to a table
Database » Most Costly Statements

Rapidly find and solve performance problems and inefficiencies with integrated “Find & Fix” workflows and interfaces to Explain and Advisors

Autonomic monitoring automatically adjusts data collection to ensure minimal monitoring overhead

Comprehensive Performance AND Configuration History makes it easy to understand performance trends and the impacts of changes

System Requirements

Product Downloads

Customer Support

How can we help?
DBI would be pleased to assist you in any way we can.
Contact DBI