DBAnalyzer

HIGHLIGHTS

• Offers a comprehensive overview of the database by a summary "health assessment", or an in-depth "checkup"

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

• Recommends index conversions which may increase performance

• Reports on characteristics and contents of individual storage areas, tables, and indexes

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 properly done.

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.