What is live lock and deadlock?
what is Lock escalation?
- 2 Answers
- 8448 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / zeeshu
LIVE LOCK: when a process is running but it doesnt do any useful work at all but it consumes the cpu time.
DEADLOCK: IN SIMPLE MEANING when a process is requesting for a resource which is held by some other process,and that process is waiting for the resource which is holding by the previous process,then there is a condition of deadlock....
converting low level lock to high level lock is lock escalation
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How many types of attribute relationships are there? : sql server analysis services, ssas
How to execute a stored procedure in ms sql server?
How exceptions can be handled in sql server programming?
Explain the different index configurations a table can have?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
Explain database normalization?
What is SQL Azure Data sync?
What is key attribute?
How many types of functions are there in sql server?
Determine how to use the inserted and deleted pseudo tables?
What are the mathematical functions supported by sql server 2005?
What are the system database in sql server 2008?
What is sql server used for?
Explain an automatic checkpoint
Name and describe few console utilities for ssrs?
