The Agents Waiting for Locks alarm becomes active when the number of registered database agents currently waiting on locks within the database reaches a threshold percentage. Lock waits occur for a number of reasons, including internal database contention.
This alarm has been predefined with a Low severity level. The underlying metric for this alarm can be adjusted to suit your environment by using the Metric Editor.
The application agents could be experiencing concurrency problems. Try to identify the applications that are holding locks for long periods of time and determine the cause. One possible solution is to use small units of work (for example, frequent COMMITs) to reduce concurrency issues.
Access the Client Application Analysis drilldown to identify the applications holding locks and review statistics about those locks.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center
