Forum

Number Of Page View:100,000+/Months
LOGIN |New User

Reply

What do you mean by Live Lock?
A livelock is a single lock which is bassically work on the request for an exclusive lock is repeatedly denied because a series of overlapping shared locks keeps interfering. A livelock also occurs when read transactions monopolize a table or page, forcing a write transaction to wait indefinitely. When four denials are cmplete then SQL Server detects the situation and refuses further shared locks. 
Posted By: Name:Rajesh Kr URL: What do you mean by Live Lock?