PERF_CLIENT_REQUESTS
This table stores the data collected by the Client Request monitor.
The table contains one record for each request sent from the client to the server. Each request is linked to the following related records:
-
Owner Operation. The active operation when the request was sent to the server.
-
Owner Method Call. The active monitored method when the request was sent to the server. It can be null.
The request record contains the following:
-
client performance data, such as the time the client sent the request to the server
-
server performance data, such as the time the request arrived at the server
The column prefix for the table is PCR
. For example, PCR_REQUEST_ID.
COLUMN NAME |
DESCRIPTION |
---|---|
REQUEST_ID |
The request unique GUID. Note: This is also the GUID of the thread that handled the request in the server. |
SEQUENCE |
The sequence of the request in the context of its owner operation. |
OWNER_OPERATION_ID |
The active client operation ID when the request was sent to the server. |
OWNER_METHOD_CALL_ID |
The active monitored method when the request was sent to the server. |
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. |
REQUEST_TYPE |
The request type, for example, PostBug. |
CLIENT_START_TIME |
The time the request was sent to the server as a date time data type. |
CLIENT_END_TIME |
The time the response returned from the server as a date time data type. |
CLIENT_START_TIME_MS |
The time the request was sent to the server as the number of milliseconds since 01/01/1970. |
CLIENT_TOTAL_TIME |
The total milliseconds that passed from the time the request was sent to the server until the response was received. |
SERVER_MACHINE_NAME |
The ALM server in which the request was processed. |
SERVER_START_TIME |
The time the server started processing the request as a date time data type. |
SERVER_START_TIME_MS |
The time the server started processing the request as the number of milliseconds since 01/01/1970. |
SERVER_TOTAL_TIME |
The total time, in milliseconds, it took for the server to process the request. |
SERVER_CPU_TIME |
The total CPU time, in milliseconds, allocated for processing the request. |
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 request. |
FS_TIME_MIN |
The minimum access time to the file system for this request. |
FS_TIME_MAX |
The maximum access time to the file system for this request. |
FS_TIME_COUNT |
The number of file system accesses (read/write or delete file) for this request. |