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

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.