Sql server - What is a live lock?

What is a live lock?

When a request for exclusive lock is denied again and again because a series of overlapping shared locks are interfering with each other and to adapt from each other they keep on changing the status, it is known as live lock.

What is a dead lock?

A dead lock occurs when 2 user processes have locks on 2 separate objects and each process is trying to acquire a lock on the object which is under the other process. SQL Server identifies dead locks and ends the dead lock by choosing one process and aborting the other process automatically. The aborted transaction is rolled back and an error message is sent to the user application. Usually, the transaction which needs the least amount of overhead to rollback is aborted.

What is a live lock?

A live lock is similar to a deadlock that the states of the processes involved in the live lock constantly change with regard to one another, none progressing. This happens when where a request for an exclusive lock is repeatedly denied because a series of overlapping shared locks keeps interfering.
What is SAND BOX in SQL server?
Sandbox is a safe place to run semi-trusted programs or scripts that originate at a third party........
Overview of SQL Server Integration Services (SSIS)
SQL Server Integration Services is used for building applications with data integration and workflow........
How can we drop an assembly from SQL SERVER?
An assembly can be dropped using DROP ASSEMBLY command........
Post your comment