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
- 47993 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
Can you force a query to use a specific index?
Can you create a logon trigger in sql server 2005 express edition?
How you can move data or databases between servers and databases in sql server?
What is the importance of concurrency control?
How to execute multiple stored procedures at one time in sql server?
Is null in sql server?
Explain different types of locks in sql server.
What are different types of statement?
Describe how to use linked server?
What is cursors?
What is a data source or ds? : sql server analysis services, ssas
What is instead of dml trigger?
Why variables called the most powerful component of ssis?
How fixed length strings are truncated and padded?
What is stretch database in sql server?
