The OpenEdge Command Center agent can monitor an OpenEdge database and collect the following performance metrics.

The OpenEdge database metrics follow the naming convention progress_oedb_<metric name>. The prefix progress_oedb indicates that the metric is specific to the OpenEdge database.

Metric Name Description
summary_commits_total The number of transactions all users have committed.
summary_undos_total The total number of transactions rolled back.
record_updates_total The total number of records updated.
record_reads_total The total number of records read.
record_creates_total The total number of records created.
record_deletes_total The total number of records deleted.
summary_dbwrites_total The total number of database blocks written to disk.
summary_dbreads_total The total number of database blocks read.
summary_biwrites_total The total number of Before-Image (BI) blocks written to disk.
summary_bireads_total The total number of BI blocks read.
summary_aiwrites_total The total number of After-Image (AI) blocks written to disk.
summary_reclocks_total The total number of record locks used.
summary_recwaits_total The total number of times users have waited to access a locked record.
summary_chkpts_total The total number of checkpoints that have been performed.
summary_flushed_total The total number of database buffers that have been flushed to disk because they were not written by the time the checkpoint ended.

reclock_waits_percent

 The percentage of record accesses that resulted in a record lock wait, which occurs when the database engine must wait to access a locked record.

bibuf_waits_percent

 The percentage of BI buffer waits, which occur when the database engine must wait to access a BI buffer.

aibuf_waits_percent

 The percentage of AI buffer waits, which occur when the database engine must wait to access an AI buffer.

apw_writes_percent

 The percentage of database blocks written to disk by the Asynchronous Page Writer (APW).

biw_writes_percent

 The percentage of BI blocks written to disk by the Before-Image Writer (BIW).

aiw_writes_percent

 The percentage of AI blocks written to disk by the After-Image Writer (AIW).

buffer_hits_percent

 The percentage of buffer hits for both the primary and alternate buffer pools. A buffer hit occurs when the database engine locates a record in the buffer pool and does not have to read the record from the disk.

primary_hits_percent

 The percentage of buffer hits for the primary buffer pool.

alternate_hits_percent

 The percentage of buffer hits for the alternate buffer pool.
instance_running_status The operational status of an OpenEdge database. It uses numerical value 1 or -1 to represent the status.
  • 1 indicates that the database is running.
  • -1 indicates that the database is stopped.