Try my app Expense Manager @ google play and amazon store.

Friday, July 13, 2012

Microsoft SQL Server Lock Escalation

Lock escalation is dynamically managed by Microsoft SQL Server. It is process of conversion of row locks and page locks into table locks thereby “escalating” the smaller or finer locks.

Lock escalation increases the system performance as each lock is nothing but a memory structure. Too many locks would mean more consumption of memory. Hence, escalation is used.

No comments:

Post a Comment

Follow by Email

Google+ Badge