Modify _Lock Scan Limit ( ) )


The lockLimit is the maximum number of _Lock entries to examine before giving up when attempting to determine who else might have a record lock. This might be attempted for every user -- so the total number of attempts could be as high as -n * lockLimit.

This can be useful, but it needs to be used with extreme caution. Scanning the _Lock table is very costly. Especially on busy production systems with -L set to large values. The use of this feature is strongly discouraged.

If you are not very sure that you need this, do NOT use it.