(DI-2308) Collector for SAP Enqueue statistics for locks
- SNP
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-2308) 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 | This parameter is used to divide the originate values retrieved from Enqueue server (by default, this value is set to 1 to keep the originate values). If this value is increased to any greater value than 1, the originate value is divided by this value. This is useful if the originate value retrieved from Enqueue server is greater than maximum integer value as KPI supports only integer values. | 1 |
VALUE_OFFSET | The offset value based on which the value from the relevant text row in enqueue statistics is retrieved. | 23 |
Troubleshooting
Troubleshooting of the big number overflow error for KPI value
In case the value of enqueue statistics row is too big (greater than maximum integer number), the following warning message “Overflow of big value for KPI '&1' (value divided by '&2')” is raised.
To be able to handle and collect KPIs also with the big values within this collector, you need to set a collector’s parameter BIG_NUMBER_DIVIDE_BY to a greater value than 1 (check the parameter “BIG_NUMBER_DIVIDE_BY” in the previous chapter).
If this parameter value is increased and any KPI value is still greater than maximum integer number, the warning message “Unsupported calculated value for the KPI '&1'“ is raised.
In this case, you must increase the parameter value into higher value again to be able to calculate the KPIs.
For each warning message raised by this collector, you can find additional details in the long text of this message as mentioned in the chapter (DI-2308) Monitoring Tabs.
Please keep in mind that after this division, the KPI value is lower than the real value.