Description
This wait is used internally to acquire the list of locks a transaction holds. It is commonly used during deadlock detection. This wait is uncommon and should be investigated if moderate values are detected
Resolved by
DBAs
Suggested solutions
- Check the SQL Server error log for more information. Look for deadlock events
- Examine other wait statistics on the instance. Investigate accordingly
- Run an Extended Event session with wait statistics to determine which requests are charging the wait
Additional research
Tracking Session and Statement Level Waits
Detecting and Ending Deadlocks