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
- 48167 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 are sql server procedures?
What is an indexing technique?
What is check constraint in sql server?
Does index speed up select statements?
How to see the event list of an existing trigger using sys.trigger_events?
What are the lambda triggers?
Explain system functions or built-in functions? What are different types of system functions?
What are the different types of normalization?
How to use subqueries with the in operators in ms sql server?
What are the types of dml?
What is use of @@ spid in sql server?
What is use of attributehierarchyenabled? : sql server analysis services, ssas
Which tcp/ip port does the sql server run on? How can it be changed?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
What are the components of sql server service broker?
