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
- 47897 Views
- Microsoft, I also Faced
- E-Mail Answers
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 orphan records?
Explain what is lock escalation?
What are different types of table joins?
How to use "begin ... End" statement structures in ms sql server?
What are number line correlation administrators will use while working with a subquery?
how would you troubleshoot blocking? : Sql server database administration
How to create a login account in ms sql server to access the database engine using "create login" statements?
What are the advantages of passing name-value pairs as parameters?
How to find the service pack installed? : sql server database administration
What is single-user mode?
Explain few of the new features of sql server 2008 management studio
If a stored procedure is taking a table data type, how it looks?
What is partition in sql server?
What are the tools available in market as an alternative to sql server reporting services?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
