Page History
...
Application server statistics, also . Also has D, H, W, and M summary levels.
| Column Name | Column Description |
|---|---|
SPRS_PWII_INSTANCE_ID | The instance ID. |
SPRS_TIMESTAMP | The time of the host samples, aligned to five minutes. |
SPRS_RECEIVED_TIMESTAMP | The received timestamp. |
SPRS_MINUTES_COUNT_SUM | The minutes count. |
SPRS_PWHG_ID | The hour group in the PW. |
SPRS_APPSVR_KEY | The sampled application server ID. |
SPRS_HOST_KEY | The host machine ID, on which the application server is installed. |
SPRS_RECORD_COUNT_SUM | Total number of samples made to the application server in the specified time. |
SPRS_USERS_AVG | Average number of connected users. |
SPRS_SESSION_COUNT_AVG | Average sessions number. |
SPRS_ACTIVE_USER_COUNT_AVG | Average number of active users in five minutes. |
SPRS_ROLL_AREA_TOTAL_AVG | Total size of roll area, in KB. |
SPRS_ROLL_AREA_IN_USE_AVG | Average size of used roll area, in KB. |
SPRS_EXTEND_MEMORY_TOTAL_AVG | Size of available extended memory, in KB. |
SPRS_EXTEND_MEMORY_IN_USE | Average size of used extended memory, meaning extended memory that is in allocated status, in KB. |
SPRS_SELECT_SINGLE_COUNT_AVG | Number of requests for database direct reads. |
SPRS_SELECT_COUNT_AVG | Number of requests for database direct and sequential reads. |
SPRS_SCREEN_HIT_RATIO_AVG | Average hit ratio of screen buffer. |
SPRS_SELECT_HIT_RATIO_AVG | Average hit ratio of DB read access. |
SPRS_PROGRAM_HIT_RATIO_AVG | Average hit ratio of program buffer. |
SPRS_SCREEN_HIT_RATIO_AVG | Average hit ratio of screen buffer. |
PW_SPHS_HOST_STAT_T
Host statistics table. Also has D, H, W, M, B, BT, BH, BD, BW, and BM summary levels.
| Column Name | Column Description |
|---|---|
SPHS_PWII_INSTANCE_ID | The instance ID. |
SPHS_TIMESTAMP | The time of the host samples (aligned to 5 minutes). |
SPHS_RECEIVED_TIMESTAMP | The received timestamp. |
SPHS_MINUTES_COUNT_SUM | The minutes count. |
SPHS_PWHG_ID | The hour group in the PW. |
SPHS_HOST_KEY | The sampled host machine ID. |
SPHS_REC_COUNT_SUM | Total number of samples made to the host in the specified time. |
SPHS_LOAD_AVG1_AVG | The average number of work processes waiting for a free processor. |
SPHS_LOAD_AVG5_AVG | The average number of work processes waiting for a free processor. |
SPHS_LOAD_AVG15_AVG | The average number of work processes waiting for a free processor. |
SPHS_INTERRUPTS_AVG | The average number of times per second the operating system had to interrupt system resources during process activity. |
SPHS_SYS_CALLS_AVG | The average number of times the operating system performed system (privileged/root) calls per second. |
SPHS_CONTEXT_SW_AVG | The average number of times the operating system had to switch CPU resources from one form of work to another per second. |
SPHS_USER_MODE_AVG | The average CPU workload caused by user processes (SAP system or database); average percentage of the CPU that is used for user processes. |
SPHS_SYS_MODE_AVG | The average CPU workload caused by operating system processes; average percentage of the CPU that is used for operating system processes. |
SPHS_IDLE_AVG | The average percentage of the CPU that was not consumed. |
SPHS_PAGE_INS_AVG | The average paging in rate per second. |
SPHS_PAGE_OUTS_AVG | The average paging out rate per second. |
SPHS_KB_PAGE_INS_AVG | The average paging in data amount (in KB) per second. |
SPHS_KB_PAGE_OUTS_AVG | The average paging out data amount (in KB) per second. |
SPHS_PHYS_MEMORY_AVG | The amount of physical operating system memory (in KB). |
SPHS_FREE_MEMORY_AVG | The average amount of free memory (in KB). |
SPHS_SWAP_CONFIG_AVG | The configured size of the swap area (in KB). |
SPHS_SWAP_FREE_AVG | The average free swap space (in KB). |
SPHS_SWAP_SIZE_AVG | The average allocated swap space (in KB). |
SPHS_SWAP_MAX | The maximum swap space (in KB) that was allocated. |
PW_SPDS_DETAILS_STAT_T
Step statistics table.
| Column Name | Column Description |
|---|---|
SPDS_PWII_INSTANCE_ID | The instance ID. |
SPDS_TIMESTAMP | The start time of the step aligned to the time grain (5 minutes). |
SPDS_RECEIVED_TIMESTAMP | The received timestamp. |
SPDS_MINUTES_COUNT_SUM | The minutes count. |
SPDS_PWHG_ID | The hour group in the PW. |
SPDS_LOCALE_KEY | The ID of the locale, on which the step took place. |
SPDS_HOST_KEY | The ID of the host machine, on which the step took place. |
SPDS_TCODE_KEY | The step's TCODE ID. |
SPDS_TRAN_KEY | The step's TCODE or Program ID. |
SPDS_PGM_KEY | The ID of the executing ABAP program. |
SPDS_USER_KEY | The ID of the user executing the step. |
SPDS_APP_KEY | The ID of application the step's TCODE belongs to. |
SPDS_ORG_KEY | The ID of the user's organization executing the step. |
SPDS_APPSVR_KEY | The ID of the application server, on which the step occurred. |
SPDS_CLIENT | The ID of the SAP client user that executed the step belongs to. |
SPDS_WORK_TYPE | The step's work type. For example: Dialog, Update, Program. |
SPDS_TRAN_TYPE | The step detailed type. For example: Login/Logout , Buffer synchronization, etc. |
SPDS_GUIPGM_NAME | The GUI program the step executed. |
SPDS_DYNPRO | The screen number. |
SPDS_STEP_COUNT_SUM | Number of identical steps per time slice. |
SPDS_QUEUE_TIME_SUM | Time spent waiting in the dispatcher for a work process (in seconds). |
SPDS_RFC_TIME_SUM | Total time spent in remote function calls (in seconds). |
SPDS_ |