
A lock escalation occurs when the number of locks held on rows and tables in the database equals the percentage of the lock list specified by the maxlocks database configuration parameter. Lock escalation is the process of converting a lot of low level locks (like row locks, page locks) into higher level locks (like table locks) to reduce the number of locks.

The title of your questions must be bit descriptive otherwise it's difficult for other user's to judge what your question is all about and that also reduce the chances to get answer quickly. So, please write a correct and descriptive title for your questions. ADMIN
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.