What is a deadlock and what is a live lock? How will you go
about resolving deadlocks?
Answer Posted / nivethitha somu
Livelock : A condition that occurs when two or more
processes continually change their state in response to
changes in the other processes. The result is that none of
the processes will complete. An analogy is when two people
meet in a hallway and each tries to step around the other
but they end up swaying from side to side getting in each
other's way as they try to get out of the way.
Deadlock : A condition that occurs when two processes are
each waiting for the other to complete before proceeding.
The result is that both processes hang. Deadlocks occur most
commonly in multitasking and client/server environments.
Ideally, the programs that are deadlocked, or the operating
system, should resolve the deadlock, but this doesn't always
happen.
Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
What are the different editions available in sql server 2000?
What are the different ways you can create databases in sql server?
How can we improve performance by using SQL Server profiler?
How to Update from select query in sql server?
What are xml indexes?
What are different types of roles provided by ssrs?
What is the web service used for reporting services?
How many non clustered indexes there can be on table ?
Explain the concept of recursive stored procedure.
What do you mean by data manipulation language?
What are the elements of dbms?
how to take backup bcp out for a column in table in sql server?
Where views are stored in sql server?
Where cross join is used?
Define magic tables in sql server?