PERF_SERVER_GENERAL_MEASURES

This table stores the data collected by the Server General monitor.

The table stores aggregated data about ALM server behavior. Each record describes a single measure on a single ALM node in a specific time frame. The column prefix for the table is PSGM. For example, PSGM_SERVER_MACHINE_NAME.

COLUMN NAME

DESCRIPTION

SERVER_MACHINE_NAME

The ALM server from which the data was collected.

START_TIME

The start time of the record's time frame.

END_TIME

The end time of the record's time frame.

MEASURE_NAME

The measure name.

Available values:

  • MEMORY_USAGE

  • ACTIVE_THREADS

  • ACTIVE_PROJECT_SESSION

  • THREAD_TOTAL_TIME

  • THREAD_CPU_TIME

  • FREC_REQUEST_CALL_TOTAL_TIME

  • DB_TIME

  • FS_TIME

AVG

The average value measured during the time frame.

MIN

The minimum value measured during the time frame.

MAX

The maximum value measured during the time frame.

COUNT

The number of times the measure was calculated during the time frame.