(DI-2005) Workload Statistics Collector
The collector for workload statistic is named: /DVD/MON_STAT_CL_COL_MODULES.
It collects statistical KPIs about transactional workload. The KPIs are defined via KPI definition and two input tables /DVD/MON_STAT_I1, /DVD/MON_STAT_I2.
Input table /DVD/MON_STAT_I1 sets extended KPI definition with following fields:
KPI name | The same technical name like in KPI definition |
KPI value result | Define how the value will be calculated. Possible options are: AVG_TIME - Average response time MAX_TIME - Maximum time MED_TIME - Median runtime MIN_TIME - Minimum time RESP_TIME - Total response time TRANS_CNT- Number of transactions |
Above [ms] | Evaluate only transactions which have runtime above the limit [optional] |
Min. hint | Evaluate only if more than x transaction[optional] |
ExTopNRunt | Exclude top N runtimes for average [optional] |
Time source | Possible values are: ‘ ‘ - Response time C - CPU time D - DB time P - Processing time G - GUI time R - Roll (in+wait) time T - Total (resp. + GUINet) time N - GUINet time |
Add to details | Add relevant statistics found for KPIs also to detail table (Yes/No) |
Change user | Last change by user [automatically filled] |
Change date | Last change date [automatically filled] |
Change time | Last change time [automatically filled] |
Input table /DVD/MON_STAT_I2 set KPI’s rules for selecting right statistics. Table has following fields:
KPI name | The same technical name like in KPI definition |
Rule number | Index of rule of same KPI |
Component | SAP Application Component ID of desired transactions [optional] For transaction without app. comp. can be used UNKNOWN |
Program name | Name of specific program or specific transaction [optional] |
User | User name whose run transaction [optional] |
Task type | Possible values [optional]: 1 Dialog process 2 Update process 3 Spool 4 Background process 5 Enqueue 6 Buffer synchronization 7 Auto ABAP 8 Update 2 9 Native RFC 10 Plugin 101 HTTP 102 HTTPs 103 NTTP 104 SMTP 105 FTP 108 LCOM 117 HTTP JSP 118 HTTPs JSP 255 CPI-C 254 RFC 253 ALE |
Job | Background Job Name |
Server | Server name |
Change user | Last change by user [automatically filled] |
Change date | Last change date [automatically filled] |
Change time | Last change time [automatically filled] |
Defining KPIs via input tables offers higher scalability to create KPIs based on customer needs without any coding. The collector provides also detailed output in detail table for relevant KPIs. The detail table is called SAP Workload Statistics - /DVD/MON_STAT_D1 with following fields:
Timestamp |
System ID |
Server name |
Application Component ID |
ABAP Program Name |
User Name |
Task type |
Background job name |
Transaction count |
Response time [ms] |
Average runtime [ms] |
Period of snapshot in seconds |
Total processing time [ms] |
Average processing time [ms] |
Rolled out time [ms] |
Average rolled out time [ms] |
Database request time [ms] |
Average database request time [ms] |
CPU time [ms] |
Average CPU time [ms] |
GUI time [ms] |
Average GUI time [ms] |
GUI network time [ms] |
Average GUI network time [ms] |
Some KPIs are provided in standard delivery with collector as examples:
KPI name | Description | Unit |
STAT_DIALOG_AVG | Average System Response Time for Users | Ms |
STAT_DIALOG_TOT | Total System Response Time for Users | Ms |
STAT_M_RESP_BC | [BC] Response time from Basis Components | Ms |
STAT_M_RESP_BW | [BW] Response time from SAP Business Inf. Warehouse | Ms |
STAT_M_RESP_XXXX | Total response time from undefined components | Ms |
STAT_M_TCNT_BC | [BC] Number of trans. from Basis Components | Count |
STAT_M_TCNT_BW | [BW] Number of trans. from SAP Business Inf. Warehouse | Count |
STAT_M_TCNT_XXXX | Number of transaction from undefined components | Count |
STAT_RSA1_AVG | Average runtime of RSA1 | Ms |
STAT_SE16_AVG | Average Response Time of Transaction SE16 | Ms |
STAT_SE16_CNT | Number of SE16 Transaction starts | Count |
STAT_SE16_TTL | Response Time of Transaction SE16 | Ms |
STAT_SE38_RESP | Response Time of Transaction SE38 | Ms |
STAT_SE38_RUN | Average Runtime of reports running via SE38 | Ms |
NOTE: All standard Workload Statistics KPIs have prefix STAT_*