Collector for SAP Enqueue Statistics for Locks

The technical name of the Collector for SAP Enqueue Statistics for Locks is /DVD/MON_CL_COL_ENQUEUE_STAT.

This collector collects information about SAP enqueue statistics for locks. KPIs for enqueue statistics can help you to identify an enqueue lock table overflow or a bottleneck. These enqueue statistics can be collected for the following enqueue servers:

• Enqueue Server: You can check the enqueue statistics for Enqueue Server in transaction SM12 by clicking Extras > Statistics.

• Enqueue Server 2: You can check the enqueue statistics for Enqueue Server 2 in transaction SMENQ by clicking Server Administration and double-clicking Monitoring > Statistics.

Enqueue Server and Enqueue Server 2 provide different outputs for collected enqueue statistics. This collector automatically detects which enqueue server is installed and being used on the monitored system. Based on this detection, it collects only the KPIs that are relevant for a specific enqueue server:

• Default KPIs for Enqueue Server

• Default KPIs for Enqueue Server 2

Default KPIs Delivered with This Collector

The following default KPIs are delivered with this collector:

Enqueue statistics records can contain a larger value than the maximum value for INT4. In this scenario, the KPI value might be not collected as expected. You can handle these large number values by following the steps described in the chapter Troubleshooting Large KPI Values.

Default KPIs for Enqueue Server

If an old Enqueue Server is installed and being 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 (logical unit of work)	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 different lock arguments in the lock table	Number
ENQ_ARG_MAX_LVL	Highest number of different lock arguments stored simultaneously in the lock table	Number
ENQ_ARG_NOW_LVL	Current number of different lock arguments stored in the lock table	Number
ENQ_BACKUP_REQ	Number of update calls for which locks were forwarded	Number
ENQ_CLEAN_REQ	Number of releases for all locks of an application server	Number
ENQ_COMPR_REQ	Number of compress operations	Number
ENQ_ENTR_MAX_CNT	Maximum number of elementary locks in the lock table	Number
ENQ_ENTR_MAX_LVL	Highest number of elementary locks stored simultaneously in the lock table	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 write accesses to file	Number
ENQ_FILE_WRT_BCK	Number of write accesses to backup file	Number
ENQ_OWN_MAX_CNT	Maximum number of lock owners in the lock table	Number
ENQ_OWN_MAX_LVL	Highest number of lock owners stored simultaneously in the lock table	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 for lock operations	Seconds [s]
ENQ_TOTAL_WAIT	Total wait time of parallel processing 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 requests with locks	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	Maximum number in search result	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 all dequeue 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 argument 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 number 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 for this collector:

Parameter name	Description	Default value
BIG_NUMBER_DIVIDE_BY	If any large number is identified for a KPI, this large number is divided by this parameter’s value.	1
VALUE_OFFSET	The offset value based on which the value from the relevant text row in the enqueue statistics is retrieved.	23

Troubleshooting Large KPI Values

If the value in the enqueue statistics row is too large, the error message Wrong value "&1" for KPI &2! appears. To resolve this issue and collect this KPI, set the collector parameter BIG_NUMBER_DIVIDE_BY to a value greater than 1, for example 1000.

When you define this parameter value, the KPI value is divided by this value. In addition, the warning message Overflow of big number ‘&1' for KPI '&2’ (value divided by '&3') appears. Note that after this division, the displayed KPI value is lower than the real value.