Preventing Lock Escalations Caused by UPDATE operations

10 בנובמבר 2008

Yoni Okun Lock Escalation is a situation in which SQL Server decides to convert many row-level locks into a Table Lock. This operation is required in order to prevent excessive memory consumption that needed to support many Lock objects and to maintain them. In effect, it is a trades-off between memory consumption and concurrency; Lock Escalation to a less-grained lock level (Table Lock) can prevent other users from accessing the table. Microsoft Support has released a nice KB article that explains this issue and provides 3 different workaround methods to prevent lock escalation. See http://support.microsoft.com/kb/323630 These methods are based on breaking the...
אין תגובות