Question - When Should You Increase The Database Parameter Maxsqllocks (maxlocks)?
Answer -
MaxSQLLocks values that are too high result in long search processes in the lock lists. Therefore, if this is possible, reduce the write transactions by using frequent commits.
You can increase MaxSQLLocks if one of the following situations frequently occur:
- There is a high number of LOCK LIST ESCALATIONS
- the number of LOCK LIST MAX USED ENTRIES equals the value of MaxSQLLocks.
- The number of LOCK LIST MAX USED ENTRIES is close to the value of MaxSQLLocks and the write transactions cannot be reduced.