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_SU M / OSLS_NUM_CPUS) / (sum(OSLS_SLICES_SUM)
*900.0)) * 100.0 (sum(OSLS_USER_CPU_SU M / OSLS_NUM_CPUS) / (sum(OSLS_SLICES_SUM)
*900.0)) * 100.0 User CPU utilization for logical processor (in percentage from total available processor power).
Oracle SQL Server Expression description
(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_SU M / OSLS_NUM_CPUS) / (sum(OSLS_SLICES_SUM)
*900.0)) * 100.0 (sum(OSLS_WAIT_CPU_SU M / 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_S UM / OSLS_NUM_CPUS) / (sum(OSLS_SLICES_SUM)
*900.0)) * 100.0 (sum(OSLS_OTHER_CPU_S UM / 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).
...