Interested to Buy Any Domain ? << Click Here >> for more details...
What is live lock and deadlock?
what is Lock escalation?
- 2 Answers
- 9148 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 is a performance monitor?
List few advantages of stored procedure.
What is the difference function and stored procedure?
How to create stored procedures with parameters in ms sql server?
Explain how to use linked server?
What is a transactions?
What are subquery and its properties?
How to modify an existing stored procedure in ms sql server?
How to maintain a fill factor in existing indexes?
what is the system function to get the current user's user id? : Sql server database administration
What are the grouping functions?
how can u get last observation in an unknown dataset ?
What is use of @@ spid in sql server?
What is the command used to check locks in microsoft sql server?
What are the disadvantages of indexes?
