Database Statistics Tool - Wiki - OpenEdge General - Progress Community

Database Statistics Tool

Database Statistics Tool

This tool helps the DBA detect when the size limit for a storage area is approaching a physical (addressing) limit. The analysis done by the tool provides a conservative view of storage area usage, i.e. there is a built-in safety margin in the reporting. The margin comes from space internal to a storage area that is actually available for the case of deleted and reused record-id's.

The downloads below include instructions on how to run the tool and interpret its results. It also includes a white paper, Best Practices For Managing Records-Per-Block Settings, which describes how to set records per block to achieve optimal performance. For more information on size limits for storage areas, see Chapter 3, "OpenEdge RDBMS Limits" in the "OpenEdge Data Management: Database Design" handbook.

The information and tools provided herein are provided "as is" without warranty of any kind. Progress Software Corporation disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. In no event shall Progress Software Corporation or its suppliers be liable for any damages whatsoever including direct, indirect, incidental, consequential, loss of business profits or special damages, even if Progress Software Corporation or its suppliers have been advised of the possibility of such damages. Some jurisdictions do not allow the exclusion or limitation of liability for consequential or incidental damages so the foregoing limitation may not apply.

Database_Statistics_Tool_Read_Me.pdf

records-per-block_best_practices_white_paper.pdf

statparseV3_03.zip (posted August 28, 2017)

Comments
  • Verion 3_01 has a small cosmetic correction in the output.  Previous versions had a column header indicating Max area size in Megabytes.  This has been corrected to Max area size in Gigabytes.