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 |
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). |