Brother-Panther

Hunt SQL Performance Problems with Speed and Agility

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.

Brother-Panther for DB2 LUW Performance Analysis

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!

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!

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.
• 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.