What is live lock and deadlock?
what is Lock escalation?
- 2 Answers
- 7794 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 clustered index
What is wide table?
Do you know how to send email from database?
What is an example of a foreign key?
Why I am getting this error when renaming a database in ms sql server?
What do you mean by the term 'normalization'?
What are commonly used mssql functions in php?
How to verify a login name with sqlcmd tool?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
How do I view views in sql server?
How to get a list of all tables with "sys.tables" view in ms sql server?
Name three of the features managed by the surface area configuration tool? : sql server security
What is xml datatype?
Can we insert data into a view?
What is data file in computer?
