Share this page

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

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: