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
- 48189 Views
- Microsoft, I also Faced
- E-Mail Answers
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
What is updatable resultset?
What are advantages of ssrs or why we should use ssrs?
What is rs.exe utility?
Can sql servers linked to other servers?
What is difference between equi join and inner join?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
When does a workload on SQL Azure get throttled?
What are the five characteristics of good data?
How to replace the Query Result 'Null Value' with a text ?
How to enter date and time literals in ms sql server?
What is sql server 2000 work load governor?
what is blocking? : Sql server database administration
How are the exceptions handled in sql server programming?
How to convert a numeric expression from one data type to another?
What is a db view?
