What is live lock and deadlock?
what is Lock escalation?
Answers were Sorted based on User's Feedback
Answer / sagi.rahul
In SQL Server Live Lock occurs when read transactions are
applied on table which prevents write transaction to wait
indefinitely and Deadlocking occurs when two user processes
have locks on separate objects and each process is trying to
acquire a lock on the object that the other process has.
Lock escalation is the process of converting a lot of low
level locks (like row locks, page locks) into higher level
locks (like table locks).
Is This Answer Correct ? | 12 Yes | 2 No |
Answer / 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 |
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
What is difference between rownum and row_number?
what is replication? where do u use Go Keyword?
What is #table in sql server?
What is bcnf normalization form?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
How does stuff differ from the replace function?
What is extent? Types of extents?
Wht is Stuff in sql ser
How can I create a new template for import ? : sql server management studio
How do you create a data source?
What is replication and database mirroring?