Page History
...
The OS process-level statistics summarized by each aggregated invocation.
Column Name | Column Description |
---|---|
OSPS_TIMESTAMP | The time summary. |
OSPS_PWHG_ID | The hour group ID. |
OSPS_PWII_INSTANCE_ID | The ID of the instance running the OS process. |
OSPS_NUM_CPUS | The number of processors on the server. |
OSPS_USER | The ID of the user running the OS process. |
OSPS_PROGRAM | The ID of the program running the OS process. |
OSPS_PATH | The ID of the command (program with arguments) running the OS process. |
OSPS_PID | The ID of the OS process. |
OSPS_PID_TIMESTAMP | The creation time of the OS process. |
OSPS_WORK_TYPE | 0 , null = general; 90 = Citrix. |
OSPS_PUB_APP | The ID of the Citrix application running the OS process. |
OSPS_APP_USER | The ID of the Citrix user running the OS process. |
OSPS_CONSUMER_IP | The ID of the Citrix client IP running the OS process. |
OSPS_CONSUMER_IP_GID | The ID of the Citrix location running the OS process. |
OSPS_CONSUMER | The ID of the Citrix client running the OS process. |
OSPS_USER_CPU_SUM | The non-idle processor time spent in user mode, specified in seconds. The user mode is a restricted processing mode designed for applications, environment subsystems, and integral subsystems. |
OSPS_SYS_CPU_SUM | The non-idle processor time spent in privileged mode, specified in seconds. The privileged mode is designed for operating system components and allows direct access to hardware and all memory. |
OSPS_WAIT_CPU_SUM | The amount of time that the processor was idle during which the system had an outstanding disk I/O request, specified in seconds. |
OSPS_OTHER_CPU_SUM | The miscellaneous non-idle processor time, specified in seconds. |
OSPS_SWITCH_SUM | The combined rate at which all processors on the server are switched from one thread to another. |
OSPS_THREADS_SUM | The average number of threads active for one process. |
OSPS_IO_SUM | The total OS I/O consumption on the server, specified in |
...
megabytes. | |
OSPS_PHY_MEM_SUM | The physical memory consumption, specified in |
...
megabytes. | |
OSPS_VIR_MEM_SUM | The virtual memory consumption, specified in |
...
megabytes. | |
OSPS_PAGING_SUM | The total OS paging on the server. |
...
OSPS_LOAD_SUM | The total server load. |
OSPS_PROC_START_SUM | The total number of processes started in this time summary. |
OSPS_PROC_SUM | The total number of processes running in this time summary. |
PW_OSLS_LCPU_STATISTICS_T
The OS statistics for the logical processor summarized by each aggregated invocation.
Column Name | Column Description |
---|---|
OSLS_TIMESTAMP | The time summary. |
OSLS_PWHG_ID | The hour group ID. |
OSLS_PWII_INSTANCE_ID | The ID of the instance running the OS process. |
OSLS_SLICES_SUM | The number of 15-minute slices in the time summary that data was reported by the OS agent for this instance. |
OSLS_LOGICAL_CPU | The processor ID (if it is on a virtual server, then we talk about the logical processor). |
OSLS_USER_CPU_SUM | The non-idle processor time spent in user mode, specified in seconds. The user mode is a restricted processing mode designed for applications, environment subsystems, and integral subsystems. |
OSLS_SYS_CPU_SUM | The non-idle processor time spent in privileged mode, specified in seconds. The privileged mode is designed for operating system components and allows direct access to hardware and all memory. |
OSLS_WAIT_CPU_SUM | The amount of time that the processor was idle during which the system had an outstanding disk I/O request, specified in seconds. |
OSLS_OTHER_CPU_SUM | The miscellaneous non-idle processor time, specified in seconds. |
Expressions
Oracle | SQL Server | Expression |
---|
...
Description |
---|
(sum(OSLS_USER_CPU_ |
...
SUM / OSLS_NUM_CPUS) / (sum(OSLS_SLICES_SUM) |
...
* 900.0 |
...
* 100.0 | (sum(OSLS_USER_CPU_ |
...
SUM / OSLS_NUM_CPUS) / (sum(OSLS_SLICES_SUM) |
...
* 900.0 |
...
* 100.0 | User |
...
SPU utilization for logical processor |
...
, in percentage from total available processor power |
...
. |
...
(sum(OSLS_SYS_CPU_SUM |
...
/ OSLS_NUM_CPUS) / (sum(OSLS_SLICES_SUM) |
...
* 900.0 |
...
* 100.0 | (sum(OSLS_SYS_CPU_SUM |
...
/ OSLS_NUM_CPUS) / (sum(OSLS_SLICES_SUM) |
...
* 900.0 |
...
* 100.0 | System CPU utilization for logical processor |
...
, in percentage from total available processor power |
...
. |
(sum(OSLS_WAIT_CPU_ |
...
SUM / OSLS_NUM_CPUS) / (sum(OSLS_SLICES_SUM) |
...
* 900.0 |
...
* 100.0 | (sum(OSLS_WAIT_CPU_ |
...
SUM / OSLS_NUM_CPUS) / (sum(OSLS_SLICES_SUM) |
...
* 900.0 |
...
* 100.0 | Wait IO CPU utilization for logical processor |
...
, in percentage from total available processor power |
...
. |
(sum(OSLS_OTHER_CPU_ |
...
SUM / OSLS_NUM_CPUS) / (sum(OSLS_SLICES_SUM) |
...
* 900.0 |
...
* 100.0 | (sum(OSLS_OTHER_CPU_ |
...
SUM / OSLS_NUM_CPUS) / (sum(OSLS_SLICES_SUM) |
...
* 900.0 |
...
* 100.0 | Other CPU utilization for logical processor |
...
, in percentage from total available processor power |
...
. | ||
Sum of above four expressions | Sum of above four expressions | Total CPU utilization for logical processor |
...
, in percentage from total available processor power |
...
. |
PW_OSLN_LCPU_N
The process statistics logical processor normalization table.
Column Name | Column Description |
---|---|
OSLN_ID | The ID of the logical processor. |
OSLN_STRING_VALUE | The name of the logical processor. |
PW_OSCS_CITRIX_STATISTICS_T
The Citrix performance counters summarized by each aggregated invocation.
Column Name | Column Description |
---|---|
OSCS_TIMESTAMP | The time summary. |
OSCS_PWHG_ID | The hour group ID. |
OSCS_PWII_INSTANCE_ID | The ID of the instance running the OS process. |
OSCS_PUB_APP | The ID of the Citrix application running the OS process. |
OSCS_APP_USER | The ID of the Citrix user running the OS process. |
OSCS_CONSUMER_IP | The ID of the Citrix client IP running the OS process. |
OSCS_CONSUMER_IP_GID | The ID of the Citrix location running the OS process. |
OSCS_CONSUMER | The ID of the Citrix client running the OS process. |
OSCS_SESSIONS_SUM | The number of Citrix sessions. |
OSCS_CLIENT_LAT_SUM | The Citrix client average latency. |
Expressions
Oracle | SQL Server | Expression |
---|
...
Description |
---|
sum(OSCS_CLIENT_LAT_ |
...
SUM / OSCS_SESSIONS_SUM) | sum(OSCS_CLIENT_LAT_ |
...
SUM / OSCS_SESSIONS_SUM) | Average client latency per Citrix session. |