IT-Conductor Blog

SAP Basis Monitoring for Application Locks and Enqueue

Posted by Linh Nguyen on Oct 11, 2018 11:32:10 AM

IT-Conductor SAP Basis Monitoring of Application Locks and Enqueue

Monitoring SAP Application Locks and Enqueue

The restriction on data modification, while a data record is being changed by another user, is to ensure data consistency within an SAP system. This is achieved through the use of enqueue service/lock management mechanism which handles locks in the lock table. This locking concept prevents concurrent access to data records by multiple users which may lead to data inconsistency.

Application Locks and Enqueue SAP IT-Conductor
  • SAP enqueue server administers the lock table by checking if requested locks do not conflict with existing locks before a new lock can be set and entered in the lock table.
  • Some important lock types in SAP that should be taken into consideration include the following:
    • Exclusive: Exclusive lock on a database object is only available to and can only be modified by the transaction that set the lock. Subsequently requested exclusive or shared locks on the same object are not permitted. The exclusive lock is released at the end of the transaction or by the respective user as long as the database object has not been changed.
    • Exclusive but not cumulative: these locks can only be called once from the same transaction and subsequently requested locks by the same transaction will not be permitted.
  • Unduly held locks can be detrimental to SAP system performance, as they can prevent other users from updating critical transactions on the system. The effect of such a problem can be avoided if the enqueue locks and general health condition of the systems are closely monitored
  • Failure to obtain a lock in SAP can result in the termination of important processes on the system which can severely impact business activities.
  • Lock resources are a finite queue and thus the limits need to be monitored and managed accordingly.  These translates to services managed by the SAP ASCS/SCS/ERS (Central Services) which includes enqueue and enqueue replication to ensure highly available lock management.
  • Lock operations can be monitored in SAP using SM12 in-built features such as the Enqueue statistics and Top capacity usage.
  • SAP Enqueue Resources can be monitored through the CCMS Infrastructure using specific monitoring functions and configuration like the MTEs of transaction RZ20.
  • At OS layer: <sid>adm can monitor enqueue and replication using ensmon utility
  • ITC contributes to the overall performance of the systems in your landscape by ensuring high responsive and reliable service levels.
  • Unduly held locks can be quickly identified using IT-Conductor monitoring features, thus averting poor system performance.
  • ITC allows you to monitor the lock operation in your system and avoid the risk of lock table overflow and excessively held locks. 
  • Important enqueue server parameters such as the lock age, error count, lock count among others can be easily captured in a graphical form using ITC.
  • SAP Hostagent Enqueue monitoring can be easily integrated to show both ABAP (ASCS) and JAVA (SCS) enqueue processes and stats
  • Enqueue monitoring functionalities in SAP is intelligently complemented by ITC through the provision of detailed metrics enabling you to quickly locate performance issues and optimize your applications across a series of related KPI's such as updates/queue/DB locks holding SAP locks


 

IT-Conductor Basis Monitoring of Locks and Enqueue Views

IT-Conductor SAP Basis - Application Locks and Enqueue Monitoring


FREE IT-Conductor Trial to Monitor SAP

Linh Nguyen

Written by Linh Nguyen

Linh was born in democratic Vietnam, escaped from the communist after the war as a boat-people refugee to Malaysia, subsequently immigrated to Australia where he attended high-school and completed dual-degrees in Computer Science & Computer Engineering in just 5 years. He started SAP career in Melbourne, then came to the US in the mid-1990s as a SAP technical consultant. He built a software and consulting company in Silicon Valley in 1996 named OZSoft and has been an entrepreneur with a passion to automate IT processes. In 2014, he started IT-Conductor, Inc. as CEO and co-founder along with David Stavisski, with the goal to help IT organizations to Stop Guessing and Start Managing by automating IT operations using a cloud-based platform IT-Conductor.

Topics: SAP monitoring, SAP Performance, Performance monitor, Application performance management, SAP Performance Service Level Management

FREE IT-Conductor Trial to Monitor SAP

Posts by Topic

see all

Recent Posts

Subscribe to Email Updates