Interested to Buy Any Domain ? << Click Here >> for more details...
What is live lock and deadlock?
what is Lock escalation?
- 2 Answers
- 9419 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
What is a field in a table?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
Explain filtered indexes?
What are ddl triggers and types of ddl trigger?
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
What is difference between commit and rollback when used in transactions?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
How do I get to sql server configuration manager?
Difference between Sql server reporting services and Crystal reports?
What happens to a trigger with multiple affected rows?
In what version of sql server were synonyms released?
How to connect Azure federated root database and apply federation in entity framework?
What is implicit mode in sql server?
What are tables in sql server?
what is an extended stored procedure? : Sql server database administration
