Share this page
This table stores the data collected by the Server Thread monitor.
The table contains one record for each thread run on the server. There are four thread categories:
-
REQUEST. Thread processing web-gate requests.
-
JOB. Threads running ALM jobs.
-
ASYNC_TASK. Threads running ALM asynchronous tasks.
-
NONE. All other threads, such as threads running the repository migration process.
The column prefix for the table is PCT. For example, PCT_THREAD_ID.
|
COLUMN NAME |
DESCRIPTION |
|---|---|
|
THREAD_ID |
The thread unique GUID. |
|
SERVER_MACHINE_NAME |
The ALM server in which the thread was processed. |
|
THREADY_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. |
|
SERVER_START_TIME |
The time the thread started to run as a date time data type. |
|
SERVER_START_TIME_MS |
The time the thread started to run as the number of milliseconds since 01/01/1970. |
|
LOGIN_SESSION_ID |
The login session ID. |
|
PROJECT_SESSION_ID |
The project session ID. |
|
PROJECT |
The domain and project name, in the format |
|
USER_NAME |
The user name. |
|
SERVER_TOTAL_TIME |
The total time, in milliseconds, it took for the server to process the thread. |
|
SERVER_CPU_TIME |
The total CPU time, in milliseconds, allocated for processing the thread. |
|
DB_TIME_AVG |
The average time the database processed an SQL statement for this thread. |
|
DB_TIME_MAX |
The maximum time the database processed an SQL statement for this thread. |
|
DB_TIME_MIN |
The minimum time the database processed an SQL statement for this thread. |
|
DB_TIME_COUNT |
The number of SQL statements processed by the database for this thread. |
|
FS_TIME_AVG |
The average access time to the file system for this thread. |
|
FS_TIME_MIN |
The minimum access time to the file system for this thread. |
|
FS_TIME_MAX |
The maximum access time to the file system for this thread. |
|
FS_TIME_COUNT |
The number of file system accesses (read/write or delete file) for this thread. |
