Livelock
A livelock is one, where a request for an exclusive
lock is repeatedly denied because a series of overlapping
shared locks keeps interfering. SQL Server detects the
situation after four denials and refuses further shared
locks. A livelock also occurs when read transactions
monopolize a table or page, forcing a write transaction
to wait indefinitely.
No comments:
Post a Comment