Share this page

# PERF_SERVER_THREADS

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 `<domain name>/<project name>`.
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.

https://admhelp.microfocus.com ALM 8942
Tips to improve your search results... ALM Help Center ALM Help Center ALM Help 15.5-15.5.1 All View Local Help Center View Online Help Center back Go back in browser history forward Go forward in browser history Remove search highlights next topic Go to next topic previous topic Go to previous topic Print the current topic Version: