What is a deadlock and what is a live lock? How will you go
about resolving deadlocks?
Answer Posted / swapna
Deadlock is a situation when two processes, each having a
lock on one piece of data, attempt to acquire a lock on the
other's piece. Each process would wait indefinitely for
the other to release the lock, unless one of the user
processes is terminated. SQL Server detects deadlocks and
terminates one user's process.
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
| Is This Answer Correct ? | 87 Yes | 10 No |
Post New Answer View All Answers
How extra digits are handled with numeric data type literals?
What is difference between order by and group by?
How to sort query output in descending order in ms sql server?
Explain powershell included in sql server 2008?
How to find the source of a table in sql server?
Does full backup break log chain?
What is the difference between update lock and exclusive lock?
Explain what is raid and what are different types of raid levels?
What is extent? Types of extents?
How do you migrate data from mssql server to azure?
How would you go about developing a ssrs report?
How to optimize stored procedure optimization?
What is a document index?
Explain the categories of stored procedure?
How to provide column names in insert statements in ms sql server?