Interested to Buy Any Domain ? << Click Here >> for more details...
What is live lock and deadlock?
what is Lock escalation?
- 2 Answers
- 9264 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the purpose of Normalisation?
Tell me what are cursors and when they are useful?
How to create user messages with print statements in ms sql server?
What are the advantages of using third-party tools?
what is the difference between openrowset and openquery?
What is Federation and Federation Member?
How do I view a stored procedure in sql server query?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
How do I find my localdb version?
How to see the event list of an existing trigger using sys.trigger_events?
Explain about SQL server 2005?
What are the differences between decimal and float in ms sql server?
How to create a dynamic cursor with the dynamic option?
What is explicit mode in sql server?
What is the difference between function and stored procedure in sql server?
