What do you mean by Live Lock?

What do you mean by Live Lock?

A live-lock is a single lock which is basically work on the request for an exclusive lock is repeatedly denied because a series of overlapping shared locks keeps interfering. A live lock also occurs when read transactions monopolize a table or page, forcing a write transaction to wait indefinitely. When four denials are complete then SQL Server detects the situation and refuses further shared locks. 

Date:2013-01-09 00:00:00

Post Your Answers

User Email:

User Name:

Related SQL Subjective Links

SQL Subjective interview questions and answers for experienced and fresher