Page History
...
The server-level OS statistics summarized by each aggregated invocation.
Column Name | Column Description |
---|---|
OSSS_TIMESTAMP | The time summary. |
OSSS_PWHG_ID | The hour group ID. |
OSSS_SLICES_SUM | The number of 15-minute slices in the time summary that data was reported by the OS agent for this instance. |
OSSS_PWII_INSTANCE_ID | The ID of the OS server instance. |
OSSS_NUM_CPUS | The number of processors on the server. |
OSSS_TOT_PHY_MEM | Installed physical memory on the server, specified in megabytes. |
OSSS_TOT_VIR_MEM | The virtual memory configured for the server (physical memory and paging file), specified in megabytes. |
OSSS_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. |
OSSS_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. |
OSSS_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. |
OSSS_OTHER_CPU_SUM | The miscellaneous non-idle processor time, specified in seconds. |
OSSS_SWITCH_SUM | The combined rate at which all processors on the server are switched from one thread to another. |
OSSS_IO_SUM | The total OS I/O consumption on the server, specified in megabytes. |
OSSS_PHY_MEM_SUM | The physical memory consumption, specified in megabytes. |
OSSS_VIR_MEM_SUM | The virtual memory consumption, specified in megabytes. |
OSSS_PAGING_SUM | The total OS paging on the server. |
OSSS_LOAD_SUM | The total server load. |
OSSS_PROC_START | The total number of processes started in this time summary. |
OSSS_PROC_SUM | The total number of processes running in this time summary. |
Expressions
Oracle | SQL Server | Expression |
---|
...
Description |
---|
sum(OSSS_LOAD_SUM) / |
...
sum(OSSS_SLICES_SUM) | sum(OSSS_LOAD_SUM) / |
...
sum(OSSS_SLICES_SUM) | Average server load for a given time range. |
...
sum(OSSS_PHY_MEM_SUM) |
...
* 1024.0 * 1024.0 / |
...
sum(OSSS_SLICES_SUM) | sum(OSSS_PHY_MEM_SUM) |
...
* 1024.0 * 1024.0 / |
...
sum(OSSS_SLICES_SUM) | Server physical memory consumption. |
sum(OSSS_VIR_MEM_SUM) |
...
* 1024.0 * 1024.0 / |
...
sum(OSSS_SLICES_SUM) | sum(OSSS_VIR_MEM_SUM) |
...
* 1024.0 * 1024.0 / |
...
sum(OSSS_SLICES_SUM) | Server virtual memory consumption. |
(sum(OSSS_PHY_MEM_SUM |
...
/ OSSS_TOT_PHY_MEM) / |
...
sum(OSSS_SLICES_SUM)) |
...
* 100.0 | (sum(OSSS_PHY_MEM_SUM |
...
/ OSSS_TOT_PHY_MEM) / |
...
sum(OSSS_SLICES_SUM)) |
...
* 100.0 | Server physical memory utilization |
...
in percentage from total server physical memory |
...
. |
(sum(OSSS_VIR_MEM_ |
...
SUM / OSSS_TOT_VIR_MEM) / |
...
sum(OSSS_SLICES_SUM)) |
...
* 100.0 | (sum(OSSS_VIR_MEM_ |
...
SUM / OSSS_TOT_VIR_MEM) / |
...
sum(OSSS_SLICES_SUM)) |
...
* 100.0 | Server virtual memory utilization |
...
in percentage from total server virtual memory |
...
. |
(sum(OSSS_USER_CPU_ |
...
SUM / OSSS_NUM_CPUS) / (sum(OSSS_SLICES_SUM) |
...
* 900.0)) * 100.0 | (sum(OSSS_USER_CPU_ |
...
SUM / OSSS_NUM_CPUS) / (sum(OSSS_SLICES_SUM) |
...
* 900.0)) * 100.0 | Server |
...
user CPU utilization |
...
in percentage from total available processor power |
...
. |
(sum(OSSS_SYS_CPU_SUM |
...
/ OSSS_NUM_CPUS) / (sum(OSSS_SLICES_SUM) |
...
* 900.0)) * 100.0 | (sum(OSSS_SYS_CPU_SUM |
...
/ OSSS_NUM_CPUS) / (sum(OSSS_SLICES_SUM) |
...
* 900.0)) * 100.0 | Server |
...
system CPU utilization |
...
in percentage from total available processor power |
...
. |
(sum(OSSS_WAIT_CPU_ |
...
SUM / OSSS_NUM_CPUS) / (sum(OSSS_SLICES_SUM) |
...
* 900.0)) * 100.0 | (sum(OSSS_WAIT_CPU_ |
...
SUM / OSSS_NUM_CPUS) / (sum(OSSS_SLICES_SUM) |
...
* 900.0)) * 100.0 | Server |
...
wait IO CPU utilization |
...
in percentage from total available processor power |
...
. |
(sum(OSSS_OTHER_CPU_S UM / OSSS_NUM_CPUS) / (sum(OSSS_SLICES_SUM) |
...
* 900.0)) * 100.0 | (sum(OSSS_OTHER_CPU_S UM / OSSS_NUM_CPUS) / (sum(OSSS_SLICES_SUM) |
...
* 900.0)) * 100.0 | Server |
...
other CPU utilization |
...
in percentage from total available processor power |
...
. | ||
Sum of above four expressions | Sum of above four expressions | Total |
...
server CPU utilization |
...
in percentage from total available processor power |
...
. |
(sum(OSSS_IO_SUM) * |
...
1024. |
...
0 * 1024.0) / (sum(OSSS_SLICES_SUM) |
...
* 900.0) | (sum(OSSS_IO_SUM) * |
...
1024. |
...
0 * 1024.0) / (sum(OSSS_SLICES_SUM) |
...
* 900.0) | Server |
...
IO throughput, |
...
specific as |
...
IO bytes per second. |
(sum(OSSS_PAGING_SUM) |
...
* 1024.0 * 1024.0) / (sum(OSSS_SLICES_SUM) |
...
* 900.0) | (sum(OSSS_PAGING_SUM) |
...
* 1024.0 * 1024.0) / (sum(OSSS_SLICES_SUM) |
...
* 900.0) | Server |
...
page faults rate, specified as paging per second. |
...
(sum(OSSS_SWITCH_SUM) |
...
* 1024.0 * 1024.0) / (sum(OSSS_SLICES_SUM) |
...
* 900.0) | (sum(OSSS_SWITCH |
...
_SUM) * 1024.0 * |
...
1024.0) / (sum(OSSS_SLICES_SUM) |
...
* 900.0) | Server |
...
context switches rate, specified as |
...
context switches per second. |
PW_OSPS_PROC_STATISTICS_T
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. |