Performance Measurement

Tools, code samples, and whitepapers related to measuring performance in deployed systems.

OESNMP: Monitoring your OpenEdge infrastructure from Any monitoring solution

Expose OpenEdge infrastructure to any monitoring platform

OESNMP is a set of utilites to expose information about OpenEdge Appservers, Databases and related infrastructure to Monitoring systems supporting SNMP. This allows you to notice unusual behaviour, verify performance tuning has the desired results, warn you before problems result in downtime,...

Table Block Mapping For Type I Areas

Many people know of the perils of record scatter and fragmentation with Type I areas. This tool provides an easy way to determine how scattered your data is and present that information in an easy to view HTML format. Primarily I use this tool to explain to non technical clients and managers why we need to migrate data from Type I to Type II areas.

You specify which tables are to be mapped by passing which areas or tables to the tool. CAN-DO style lists are supported in order to easily exclude larger tables from the list.

OpenEdge Database Advisor

The OpenEdge Database Advisor is intended to provide a quick checkup for common database configuration issues. Obviously proper tuning for an application requires much more than any tool can provide, but the advisor should highlight some of the most common low hanging fruit.

For best results you will need a recent database analysis file (proutil -C dbanalys) and you should run this against your production database. A large portion of the suggestions will be based on VST information that will differ greatly between your production and test environments.

Log Based Memory Leak Finder

This program reads log files for logentrytype dynobjects and produces an output of those log file entries where objects were created, but not deleted.

4GLTrace LOG-MANAGER Reporter

Reads output from a LOG-MANAGER:LOG-ENTRY-TYPE = "4GLTRACE:4" and reports the line number, date, time, statement elapsed time, total elapsed time, nesting level, action, action adjective, and remaining data in a columnar format

Database Statistics Tool

This tool helps the DBA to detect when the size limit for a storage area is approaching a physical (addressing) limit.

Performance Measurement & Testing

Many sites become concerned about the performance of their ABL application at some time in the history of the site. While a big performance boost can often be achieved by simply moving to newer (and probably cheaper) hardware, this is not always an option, either because a reasonably powerful machine is already in use or there isn't sufficient budget for a change. The following links have been collected to provide some help for those concerned with performance.

Log Reader

The logreader tool provides a means to read one or more Progress / OpenEdge related logs from one or more Progress / OpenEdge components (i.e.

Database Statistics Tool

This tool helps the DBA to 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-ids.

The download includes instructions on how to run the tool and interpret its results as well as 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 of 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.

added by:
DB Struct Tool

Log Read utility

LogRead is a GUI utility to read, query, sort, merge and translate log files from all Progress components (e.g. AdminServer, AppServer, Messenger). It is provided as a diagnostic utility to assist in the analysis of log files. LogRead is a 4GL application that runs only on the Progress Windows Client. It is distributed as r-code, for 9.1E and 10.0B.

added by:
Garry Hall

Syndicate content