Lock Related Issues

Sometimes, a rare situation can occur where a lock is never freed.

The workflow for troubleshooting locks is:

1. Identify which statement has obtained locks.

2. Understand if the statement is itself stuck, or waiting for another statement.

3. Try to stop the offending statement, as in the following example:

SELECT STOP_STATEMENT(2484923);