a comprehensive overview of the database by a summary "health
assessment", or an in-depth "checkup"
integrity, complexity, and tunability
Scans for and
highlights potential "trouble spots" including
extended storage areas and snapshot files, tables w/out
indexes, storage areas with "mixed" contents, etc.
conversions which may increase performance
characteristics and contents of individual storage areas, tables,
DBAnalyzer provides the necessary analysis functions to improve your end-user response times
and maximize your application availability by pinpointing those
areas of your database which are hindering performance.
DBAnalyzer performs many analysis functions
that can lead to improved application performance and availability.
Some of these include listing those tables with highest record
counts, indices with most duplicates, tables with most columns and
longest records, sorted indices recommended to be hashed, hashed
indices recommended to the sorted, non-indexed tables with most
records, storage areas with most mapped items, storage areas
with most file extensions, and listing those RDA and SNP files with
most extension blocks.
Database Index Analysis
Having the wrong 'type' of index on your data often results in poor
retrieval performance. Hashed indexes perform best for
"exact" matches such as part numbers or social security
numbers. Sorted indexes perform best for "range"
retrievals. DBAnalyzer analyses the column conventions and
highlights those which may serve as the basis for new hashed
or sorted indexex.
Tuning, Integrity, and Complexity Ratings
The tune rating
measures significant factors that affect the
physical storage design. It does not consider every factor, but
does objectively measure factors critical to successful Rdb tuning.
Remember that overall performance is a factor of many things,
including system load, system tuning, and application design, in
addition to the physical storage strategy.
The Database Integrity Rating is an
overall measure of the utilization of database constraints for
database columns, and foreign keys. A low rating indicates that many
additional constraints could be implemented to improve database
integrity. As more tables and indices are added to the database,
this rating may drop unless a corresponding number of constraints
are added as well.
The complexity rating is a weighted
measure of the database design and its stored records. If tuning
requirements are high, performance degradation is expected if not
The Next Step
Once you have
identified your problem areas, you can use DBXact
and DBTune to improve your Rdb database
performance, and reduce expensive and un-necessary downtime.