The maximum number of locks held during this transaction.
Event Type | Logical Data Grouping | Monitor Switch |
---|---|---|
Transactions | event_xact | - |
You can use this element to determine if your application is approaching the maximum number of locks available to it, as defined by the maxlocks configuration parameter. This parameter indicates the percentage of the lock list that each application can use before lock escalations occur. Lock escalations can result in a decrease in concurrency between applications connected to a database.
If you have a large number of locks, you may need to perform more commits within your application so that some of the locks can be released.