Page History
...
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.
...