/SDF/SMON_WPINFO - Snapshot Monitoring - Work Prozess Information
Snapshot Monitoring - Work Prozess Information information is stored in SAP table /SDF/SMON_WPINFO.
It is part of development package /SDF/SMON in software component SV-SMG-DIA. This development package consists of objects that can be grouped under "Snapshot Monitor".
It is part of development package /SDF/SMON in software component SV-SMG-DIA. This development package consists of objects that can be grouped under "Snapshot Monitor".
Fields for table /SDF/SMON_WPINFO
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| .INCLUDE | X | /SDF/SMON_KEY | 0 | |||
| GUID | GUID for Snapshot Analysis | X | /SDF/SMON_GUID | CHAR | 44 | |
| DATUM | Date of Snapshot | X | /SDF/SMONDATE | DATS | 16 | |
| TIME | Time of Snapshot | X | /SDF/SMONTIME | TIMS | 12 | |
| SERVER | Application Server Instance | X | SSI_SERVERNAME_DISP | CHAR | 80 | |
| WP_INDEX | Work Process Number | X | SSI_WORKER_INDEX | INT4 | 4 | |
| PID | Process ID of Operating System | SSI_WORKER_PID | INT8 | 8 | ||
| STATE | State of Work Process | SSI_WORKER_STATE | INT4 | 4 | ||
| STATE_INFO | Additional State Information | SSI_WORKER_STATE_INFO | INT4 | 4 | ||
| SEM_LOCKING | Semaphore that the work process is waiting for | WPSEM | CHAR | 4 | ||
| SEM_LOCKED | Locked Semaphore of a Work Process | SSI_SEM_LOCKED_DISP | CHAR | 64 | ||
| PRIORITY | Priority | SSI_PRIORITY | INT4 | 4 | ||
| FAILURES | Number of Work Process Failures | SSI_WORKER_FAILURES | INT4 | 4 | ||
| RESTART | Restart work process after dump? | WPRESTART | CHAR | 8 | ||
| TENANT | Client | /SDF/SMON_CLNT | CHAR | 6 | ||
| USER_NAME | User ID | SSI_USER_NAME | CHAR | 24 | ||
| LOGON_HDL | Logon Key | SSI_LOGON_HDL | INT4 | 4 | ||
| LOGON_ID | Logon ID | SSI_LOGON_ID | INT4 | 4 | ||
| SESSION_HDL | Back-End Session Handle | SSI_SESSION_HDL | INT4 | 4 | ||
| LOGON_TYPE | Type of User Session | SSI_LOGON_TYPE | INT4 | 4 | ||
| LOGON_SUB_TYPE | Type of User Session | SSI_LOGON_TYPE | INT4 | 4 | ||
| CPU_SYSTEM | CPU Time | SSI_CPU_TIME | FLTP | 8 | ||
| CPU_USER | CPU Time | SSI_CPU_TIME | FLTP | 8 | ||
| CPU_SYS_MS | System CPU time in ms | /SDF/SMON_CPU_SYS_MS | D16D | 8 | ||
| CPU_TOT_MS | CPU time in ms | /SDF/SMON_CPU_TOT_MS | D16D | 8 | ||
| DBRECORDS | Number of fetched records | /SDF/SMONDBCNT | D16D | 8 | ||
| DBRECORDS_C | No. of modified records | /SDF/SMONDBCNT_C | D16D | 8 | ||
| DBTIME | Database Time | /SDF/SMONDBTIM_R | D16D | 8 | ||
| DBTIME_C | Database Time (Change Operations) | /SDF/SMONDBTIM_C | D16D | 8 | ||
| DELTATIMEMS | Time since last measurement in ms | /SDF/SMON_DELTATIMEMS | D16D | 8 | ||
| MEMSUM | Extended Memory Consumtion in kB | /SDF/SMON_MEMSUMKB | D16D | 8 | ||
| PRIVSUM | Heap Memory Consumtion in kB | /SDF/SMON_PRIVSUMKB | D16D | 8 | ||
| ELAPSED_TIME | Runtime of Request | SSI_ELAPSED_TIME | INT4 | 4 | ||
| WP_PROGRAM | Name of Program Being Executed by the Work Process | SSI_PROGRAM | CHAR | 80 | ||
| MAIN_PROGRAM | Name of Main Program | SSI_MAIN_PROGRAM | CHAR | 80 | ||
| CURRENT_ACTION | Current Action of Worker | SSI_WORKER_ACTION | INT4 | 4 | ||
| ACTION_INFO | Table | /SDF/SMON_TABLE | CHAR | 128 | ||
| APPLICATION | Application | /SDF/SMON_APPLICATION | CHAR | 264 | ||
| APPLICATION_INFO | Application Info | /SDF/SMON_APPL_INFO | CHAR | 264 | ||
| START_OF_WAIT | Time Stamp (Number of Seconds Since 1.1.1970) | SSI_TIMESTAMP | INT8 | 8 | ||
| WAIT_FOR | Wait for | CHAR | 264 | |||
| WAIT_INFO | Wait Info | CHAR | 264 | |||
| WP_TYPE | Internal work process type | WPITYPE | INT1 | 1 | ||
| ROOTTYPE | SQL Monitor: Request Type | /SDF/SMON_ROOTTYPE | CHAR | 2 | ||
| ROOTNAME | Entry Point (Transaction, etc.) | /SDF/SMON_ROOTNAME | CHAR | 120 | ||
| BTCJOBNAME | Background Job Name | BTCJOB | CHAR | 64 | ||
| BTCJOBCNT | Job ID | BTCJOBCNT | CHAR | 16 | ||
| CONTEXT_ID | ID of Context (External Session) | PFCONTEXTID | CHAR | 80 | ||
| STARTTIME1 | Time value in raw statistics record | STA_TIMERE | INT4 | 4 | ||
| STARTTIME2 | Time value in raw statistics record | STA_TIMERE | INT4 | 4 | ||
| TRACE_LEVEL | Trace Level | SSI_TRACE_LEVEL | INT1 | 1 | ||
| STACK_GUID | Globally Unique Identifier | GUID | RAW | 16 |