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
- 47898 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 the difference between a view and a stored procedure?
What is the order by used for?
How to create indexed view?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
Do you know what are the properties of the relational tables?
What is nolock hint in sql server 2008
What are the restrictions applicable while creating views? : SQL Server Architecture
What command is used to delete a table from the database in the sql server and how?
How to find table changes in sql server?
What type of Index will get created after executing the above statement?
How can sql server instances be hidden?
Explain syntax for viewing, dropping and disabling triggers?
What is policy management?
What is @@error in sql?
How is foreign key related to primary key?
