(DI-2302) Collector for SAP Enqueue statistics for locks
The technical name of the Collector for SAP Enqueue statistics for locks monitoring is /DVD/MON_CL_COL_ENQUEUE_STAT.
This collector collects information about SAP enqueue statistics for locks. KPIs for enqueue statistics might help you to identify the enqueue lock table overflow or bottlenecks. These enqueue statistics might be collected for:
Enqueue Server - enqueue statistics for Enqueue Server can be checked in transaction SM12 (Extras > Statistics)
Enqueue Server 2 - enqueue statistics for Enqueue Server 2 can be checked in transaction SM12 or SMENQ (Server Administration > Monitoring > Statistics).
Enqueue Server 2 is already available for higher SAP releases or S/4 HANA systems.
Enqueue Server and Enqueue Server 2 provide different outputs for collected enqueue statistics. This collector automatically detects which enqueue server is installed and used on the monitored system. Based on this detection, it collects only the KPIs which are relevant for a specific enqueue server:
Default KPIs delivered with this collector
The following default KPIs are delivered with this collector:
Enqueue statistics records can contain a bigger value than the maximum value for INT4 and in this scenario, the KPI value might be not collected as expected. These big number values can be handled according to the steps described in the section (DI-2302) Collector for SAP Enqueue statistics for locks.
Default KPIs for Enqueue Server
If an old Enqueue Server is installed and used on the monitored SAP system, the following default KPIs are collected:
KPI name | Description | Unit |
|---|---|---|
DEQ_ALL_REQ_CNT | Number of releases of all locks of an LUW | Number |
DEQ_ERROR_CNT | Number of errors that occurred when releasing locks | Number |
DEQ_REQUEST_CNT | Number of release requests (DEQUEUE) | Number |
ENQ_ARG_MAX_CNT | Maximum number of diff. lock arguments that the LT can contain | Number |
ENQ_ARG_MAX_LVL | Maximum number of diff. lock arg. stored simultaneously in the LT | Number |
ENQ_ARG_NOW_LVL | Current number of different lock arguments in the lock table | Number |
ENQ_BACKUP_REQ | Number of releases of all locks of an application server | Number |
ENQ_CLEAN_REQ | Maximum number of elementary locks that the LT can contain | Number |
ENQ_COMPR_REQ | Number of Compress operations | Number |
ENQ_ENTR_MAX_CNT | Maximum number of elementary locks that the LT can contain | Number |
ENQ_ENTR_MAX_LVL | Maximum number of elementary locks stored simultaneously in the LT | Number |
ENQ_ENTR_NOW_LVL | Current number of elementary locks in the lock table | Number |
ENQ_ENTR_P | Usage of SAP lock table | % |
ENQ_ERROR_CNT | Number of errors that occurred during lock requests | Number |
ENQ_FILE_WRITE | Number of writes accesses to file | Number |
ENQ_FILE_WRT_BCK | Number of write accesses to the backup file | Number |
ENQ_OWN_MAX_CNT | Maximum number of lock owner IDs that can be stored in the LT | Number |
ENQ_OWN_MAX_LVL | Maximum number of lock owners stored simultaneously in the LT | Number |
ENQ_OWN_NOW_LVL | Current number of lock owners in the lock table | Number |
ENQ_REPORT_REQ | Number of operations for reading the lock table | Number |
ENQ_REQUEST_CNT | Number of lock requests | Number |
ENQ_REQUEST_CNTD | Number of lock requests per minute since the last run | */min |
ENQ_REQ_REJ_CNT | Number of rejected lock requests | Number |
ENQ_REQ_REJ_CNTD | Number of rejected lock requests per minute since the last run | */min |
ENQ_TOTAL_TIME | Total time spent in the critical path of the LT for lock op. | Seconds [s] |
ENQ_TOTAL_WAIT | Total wait time of par. proc. before entering the critical path | Seconds [s] |
ENQ_TOT_SER_TIME | Total time spent in the enqueue server | Seconds [s] |
ENQ_UPD_MAX_CNT | Maximum number of open update req. with locks occurred so far | Number |
ENQ_UPD_NOW_LVL | Current number of open update requests with locks | Number |
ENQ_VERIFY_REQ | Number of Verify operations | Number |
Default KPIs for Enqueue Server 2
If a new Enqueue Server 2 is installed and used on the monitored SAP system, the following default KPIs are collected:
KPI name | Description | Unit |
|---|---|---|
ENQ_SER2_ADMIN_REQUESTS | Number of Administration Requests | Number |
ENQ_SER2_AVG_NUM_SEARCH | Average Number in Search Results | Number |
ENQ_SER2_AVG_NUM_TAKEOVER | Average Number in Takeover Replica | Number |
ENQ_SER2_AVG_NUM_UPDATE | Average Number in Update Replica | Number |
ENQ_SER2_BACK_REC_WRITTEN | Number of Backup Records Written | Number |
ENQ_SER2_CPU_SER_TIME | CPU Time of Enqueue Server | Seconds [s] |
ENQ_SER2_DATA_RECEIVED | Received Data | GB |
ENQ_SER2_DATA_SENT | Sent Data | GB |
ENQ_SER2_ERRORS_CONN | Number of Connection Errors | Number |
ENQ_SER2_ERRORS_SERVER | Number of Server Errors | Number |
ENQ_SER2_LOCKS_CONFIG | Configured Number of Locks | Number |
ENQ_SER2_LOCKS_CURRENT | Current number of Locks | Number |
ENQ_SER2_LOCKS_PEAK | Peak Number of Locks | Number |
ENQ_SER2_LOCKS_TOTAL_CNT | Total Number of Locks | Number |
ENQ_SER2_LOCK_COLLISIONS | Number of Lock Collisions | Number |
ENQ_SER2_MAX_NUM_SEARCH | Number of Lock Collisions | Number |
ENQ_SER2_MAX_NUM_TAKEOVER | Maximum Number in Takeover Replica | Number |
ENQ_SER2_MAX_NUM_UPDATE | Maximum Number in Update Replica | Number |
ENQ_SER2_NETWORK_REQ | Number of Network Requests | Number |
ENQ_SER2_OP_ALL_DEQUEUE | Number of Dequeue All Operations | Number |
ENQ_SER2_OP_BACKUP | Number of Backup Operations | Number |
ENQ_SER2_OP_DEQUEUE | Number of Dequeue Operations | Number |
ENQ_SER2_OP_ENQUEUE | Number of Enqueue Operations | Number |
ENQ_SER2_OP_READ | Number of Read Operations | Number |
ENQ_SER2_OP_REMOVE | Number of Remove Operations | Number |
ENQ_SER2_OP_REM_ARG_PATT | Number of Remove Arguments Pattern Operations | Number |
ENQ_SER2_OP_REM_OWN_PATT | Number of Remove Owner Pattern Operations | Number |
ENQ_SER2_OP_REPL_CONFIG | Number of Configure Replica Operations | Number |
ENQ_SER2_OP_REPL_TAKEOVER | Number of Takeover Replica Operations | Number |
ENQ_SER2_OP_REPL_UPDATE | Number of Update Replica Operations | Number |
ENQ_SER2_OP_TOTAL_CNT | Total of Lock Operations | Number |
ENQ_SER2_OVERFLOWS_LOCK_TAB | Number of Lock Table Overflows | Number |
ENQ_SER2_OVERFLOWS_SESSION | Number of Session Overflows | Number |
ENQ_SER2_PROCESS_TIME | Processing Time for Lock Operations | Seconds [s] |
ENQ_SER2_ROLL_IN | Number of Roll-Ins of Connection | Number |
ENQ_SER2_ROLL_OUT | Number of Roll-Outs of Connection | Number |
ENQ_SER2_TIMEOUTS | Number of Timeouts | Number |
ENQ_SER2_WAIT_TIME | Waiting Time for Lock Operations | Seconds [s] |
Parameters
The following parameters are used in this collector:
Parameter name | Description | Default value |
|---|---|---|
BIG_NUMBER_DIVIDE_BY | If any big number for KPI is identified, this big number is divided by this parameter’s value. | 1 |
VALUE_OFFSET | The offset value is based on which the value from the relevant text row in enqueue statistics is retrieved. | 23 |
Troubleshooting of big number for KPI value
In case the value of enqueue statistics row is too big, the following error message “Wrong value "&1" for KPI &2!” is raised.
To be able to collect this KPI, you need to set a collector’s parameter BIG_NUMBER_DIVIDE_BY to a greater value than 1 (e.g. 1000).
When this parameter value is set, the KPI value is then divided by this value and the following warning message “Overflow of big number ‘&1' for KPI '&2’ (value divided by '&3')” is raised.
Please keep in mind that after this division, the KPI value is lower than the real value.