What is live lock and deadlock?
what is Lock escalation?
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 enforce security in sql server? : sql server security
How to modify the underlying query of an existing view?
How to get the definition of a trigger back?
What is multilevel indexing?
What is the use of tempdb? What values does it hold?
How to delete an existing row with delete statements in ms sql server?
What is a cache in ssrs?
Explain about Normalization?
How to create an multi-statement table-valued function?
What is system stored procedures?
What are user-defined functions (udfs) in sql server?
Tell me what is fill factor?
What are ddl (data definition language) statements for tables in ms sql server?
What is the difference RDBMS and Graph Database?
What is stored procedures?