Team with the best
Database Performance Tools
company in the World
Database Performance Tools
company in the World
| Feature/Capability |
DBI
Performance Tools |
IBM
OPM |
Quest/
DELL |
| Exploits US Patented SQL Workload Analysis to compress SQL statement workloads and aggregate total and relative costs for each statement so that the DBA can find the statements that are truly the most harmful to performance and database efficiency. |
|
|
|
| Industry Breakthrough! Provides the ability to compare database and SQL workload performance, side by side, for two different timeframes! Now, after upgrading DB2, applying a fixpack, or implementing an application change, you can discover exactly where performance improved or degraded, and by how much! In just TWO mouse clicks! |
|
|
|
| Industry Breakthrough! For any specified time period, provides the capability to summarize the application programs and users that were executing in the database with total, average, and relative costs, plus provides drill downs to the SQL executed by programs and users. |
|
|
|
| Industry Breakthrough! Given any SQL statement in a workload, provides the ability to reverse engineer which Users or Programs executed the statement within a specific timeframe of interest along with total costs, relative costs, and averages. |
|
|
|
| Industry Breakthrough! Provides recommendations for optimal use of Solid State Disk (SSD) in just two mouse clicks! |
|
|
|
| Provides a Database Score, like a credit score, for each database and database partition to make it easy to compare and triage which databases need the most urgent help, and which partitions suffer from load imbalance and skew. |
|
|
|
| Supports DB2 9 pureXML by providing XDA performance metrics in addition to relational metrics, and is able to process xQuery statements in context alongside regular SQL statements. |
|
|
|
| Provides the ability to store and save several months or years of database, partition, bufferpool, tablespace, and statement performance, along with configuration history, over a light weight network connection into a relatively small storage footprint. |
|
|
|
| Provides performance trend charts for key metrics over any captured historical time period along with integrated significant change events plotted on the performance graphs. With this capability, the DBA team can visually see, compare, and verify the performance consequences of configuration changes, memory changes, STMM memory changes, registry variable changes, index changes and more. Chart drill downs show the DBA details of the tracked changes. If you want to have confidence that a change actually improved performance, or if you want to trust STMM to optimize memory performance, this capability is essential! |
|
|
|
| Provides the ability to graph the performance of any individual statement, dyanmic or STATIC, over time with correlated change events plotted on the graphs. Now you can see if the performance of a statement is improving or degrading, and verify that changes have contributed to improved performance. |
|
|
|
| Provides the ability to attach "Sticky Note" follow up flags to statements within a workload. Sticky note follow up flags provide a scratch pad for team members to take electronic notes and collaborate. |
|
|
|
| Provides the capability to easily find all SQL statements driving I/O to a given table, even if the SQL references view names, views on views, aliases or STATIC SQL. This ability is critically important because the IBM Design Advisor makes recommendations at the TABLE level (indexes, MDC, MQT, partitioning keys) and optimized results are achieved by giving the IBM Design Advisor a WORKLOAD of the most costly statements accessing a table. |
|
|
|
| For a given statement, provides integrated workflows to Explain and DB2 Advisor utilities. (To be fair, we thought we should give the other guys some check marks). |
|
|
|
| Provides basic DB2 performance metrics such as bufferpool, catalog cache, and package cache hit ratios, log space utilization. Bufferpool hit ratios are folly! Read the blog post on bufferpool folly... |
|
|
|
| Provides genuinely helpful performance metrics such as Index Read Efficiency (IREF), Asynchronous Pages Read per Request (APPR), Cost metrics useful for detecting scans ( TBRRTX, BPLITX), and integrates OS statistics such as CPU busy%, Paging, and Memory alongside DB2 performance metrics. |
|
|
|
| Provides the ability to measure average database transaction response times for any selected time period along with graphically showing how much time is spent inside DB2 and out, where the inside database time goes (what resource is the bottleneck), and Service Level Agreement attainment counts and percentages. At last, DBAs and their managers have a means to determine if a performance problem is a database problem or not, and, if so, quickly isolate and cure the problems! Read the blog post on Performance Accountability... |
|
|
|
| Provides basic DB2 alert capability on par with the DB2 Health Monitor. |
|
|
|
| Provides the industry's most advanced lights out alert capability on real-time and near real-time computed metrics, and allows you to create an alert rule based on any performance, availability, or business data. Alerts can be sent via email, SMS text page, or SNMP Trap alerts to central consoles such as IBM Tivolia. By advanced alerts, we mean the ability to send an alert if, for example, any one SQL statement uses more than 50% of the CPU during the prior 30 minutes, or if during the prior 60 minutes fewer than 95% of transactions completed within the defined target SLA. |
|
|
|
| Provides a fancy (eye-candy) capability to generate and benchmark query re-writes. Since the DB2 optimizer brilliantly re-writes SQL, we have to ask the question - isn't re-writing re-written SQL redundant? And, if you are running a packaged vendor application, can you really modify their SQL? |
|
|
|
| Stores DB2 LUW performance data in an ORACLE database. |
|
|
|
| Recently acquired by hardware company that aspires to become a company focused on Data Centers, various stock transactions being contemplated, focus and future of DB2 tools at this company uncertain since DELL has tight alliance partnerships with Oracle and Microsoft. |
|
|
|
| Ready for IBM DB2 LUW V10.5 BLU. Generally ready on Day 1 to support new DB2 LUW releases and versions. |
|
|
|
| Estimated Installation Time | 60-90 Minutes | Days | Hours |
| Overhead. With IBM Optim Performance Manager, plan on adding CPUs to monitored server just to offset its very high overhead. | ~1-3% | ~20-35% | ~10-20% |
