What is live lock and deadlock?
what is Lock escalation?
- 2 Answers
- 7802 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
How to rebuild all indexes on a single table?
What is triggers in ms sql server?
How do you delete a data source?
What part does database design plays a role in performance of an sql server-based application?
Does the unique constraint create an index?
What are filegroups in sql server?
What is your recommendation for a query running very slow? : sql server database administration
What is table-valued sub query?
What are the advantages of using stored procedures?
What is an etl file?
How to insert stored procedure result into temporary table?
how to define testing of network layers? : Sql server database administration
explain different types of constraints? : Sql server database administration
What happens if the update subquery returns no rows in ms sql server?
Define magic tables in sql server?
