Interested to Buy Any Domain ? << Click Here >> for more details...
What is a deadlock and what is a live lock? How will you go
about resolving deadlocks?
- 7 Answers
- 47675 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / kkkkkk
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 processDeak Lock is a situation when two or more process
continuous working and each having a lock on a particular
record but at a time only one can lock a particular and the
other one will go to dead lock.
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.A human example of live lock would be two people who meet
face-to-face in a corridor and each moves aside to let the
other pass, but they end up moving from side to side without
making any progress because they always move the same way at
the same time and never cross each other. This is good
example of live lock.
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
What is msdb database? : SQL Server Architecture
What is 2nf normalization?
Define full outer join in sql server joins?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
How to generate random numbers with the rand() function in ms sql server?
how many clustered indexes can be created on a table? : Sql server database administration
How to verify a user name with sqlcmd tool?
What are the properties of the transactions?
How to use “drop” keyword in sql server and give an example?
Explain the steps needed to create a scheduled job?
How to disable triggers using "disable trigger"?
What is difference between line feed ( ) and carriage return ( )?
Difference between report and query parameter. Why do we need different type of parameter?
What is raid, and how it can influence database performance?
What are relationships and mention different types of relationships in the dbms
