PERF_SERVER_THREAD_TYPES

This table stores the data collected by the Server Thread Type monitor.

The table stores aggregated data about server threads. Each record describes a single thread type behavior on a single ALM node in a specific time frame in a specific ALM project. The column prefix for the table is PSTT, for example, PSTT_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.

THREAD_CATEGORY

The thread category. Available categories: REQUEST, JOB, ASYNC_TASK, NONE.

THREAD_TYPE

The thread type. For example, request type – PostBug, Job Name – CKeepAliveJob, etc.

PROJECT

The domain and project name, in the format <domain name>\<project name>.

SERVER_TOTAL_TIME_AVG

The average time, in milliseconds, it took for the server to process a thread.

SERVER_TOTAL_TIME_MIN

The minimum time, in milliseconds, it took for the server to process a thread.

SERVER_TOTAL_TIME_MAX

The maximum time, in milliseconds, it took for the server to process a thread.

SERVER_TOTAL_TIME_COUNT

The number of threads that run in the server.

SERVER_CPU_TIME_AVG

The average CPU time, in milliseconds, allocated for processing a thread.

SERVER_CPU_TIME_MIN

The minimum CPU time, in milliseconds, allocated for processing a thread.

SERVER_CPU_TIME_MAX

The maximum CPU time, in milliseconds, allocated for processing a thread.

SERVER_CPU_TIME_COUNT

The number of threads that run in the server.

DB_TIME_AVG

The average time for processing an SQL statement.

DB_TIME_MIN

The minimum time for processing an SQL statement.

DB_TIME_MAX

The maximum time for processing an SQL statement.

DB_TIME_COUNT

The number of SQL statements processed by the database.

FS_TIME_AVG

The average access time to the file system.

FS_TIME_MIN

The minimum access time to the file system.

FS_TIME_MAX

The maximum access time to the file system.

FS_TIME_COUNT

The number of file system accesses (read/write or delete file).