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