www.dbisoftware.com Open in urlscan Pro
64.130.45.51  Public Scan

Form analysis
0 forms found in the DOM

Text Content

Please enable JavaScript. Certain features of the site will not work properly
without JavaScript.
Team with the best
Database Performance Tools
company in the World
Home Products Stories Demo Downloads Support Contact About News Db2NightShow


COMPARING DB2 LUW PERFORMANCE TOOLS

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%


DB2 PERFORMANCE TOOLS COMPARISON



Most DBI customers achieve 30-90% CPU utilization reductions and measurably
improved response times within just a few hours of using DBI's suite of
integrated performance tools for DB2 LUW!

No other solution provider can help you cut IT costs and simultaneously improve
business performance like DBI can! This is the ultimate difference!

--------------------------------------------------------------------------------

The integrated suite of DBI DB2 LUW Performance Solutions includes:
Brother-Panther® :: SQL Workload Analysis & Tuning, Performance Trends, and
monitoring and analysis for all aspects of database and partition performance.

Brother-Thoroughbred® :: Advanced Transaction Time Analysis, Inside & Outside
DB2 Time, and SLA attainments. Brother-Hawk™ :: The industry's most advanced
Lights-Out alerting capability for proactive problem prevention and rapid
identification of database performance and availability issues.

Brother-Eagle® :: Real-time performance monitoring of "What's happening right
now?!?!?!" presented in a unique stock ticker format that doesn't waste the
DBA's entire screen - complete with drill downs to details (Enterprise Edition
only) and expert tuning advice.


EXPLORE

Home
Products
Licensing
Services
Testimonials
Events
Downloads



JUST FOR YOU

For DBAs
For Executives
For IT Managers
For Systems Integrators
Join the Top 1 percent
Do your due diligence
Free DB2 Performance Tools



BUSINESS

Cloud Computing
Customer Satisfaction
Customer References Employee Productivity
Maximizing Profitability
GREEN IT/Saving Energy
Return on Investment (ROI)



OPERATIONS

Achieving SLAs
Infrastructure Costs
Stability & Reliability
SQL Server Performance
Rapid Problem Resolution
Performance Optimization
Improving Response Times



THE TEAM

About
Contact
Support
News
Legal
Privacy
Sitemap


Share Facebook Twitter LinkedIn

Copyright © 2005–2023 All rights reserved. 3rd Millennium, Inc. - 125 Cambridge
Park Drive, Suite 301 - Cambridge, MA 02140 USA
✓
Thanks for sharing!
AddToAny
More…