|
What is blocking? Blocking is similar to the case of a child holding a ball and all other children waiting to get hold of the same ball.
Blocking in SQL Server means one connection is holding a lock on a resource when other connections are waiting to use the same resource for reading or writing.
Deadlock is different than a Blocking.
We can relate deadlock to the case of two children each having a ball but wants to acquire each other ball.
When two users have locks on separate objects and each process is trying to acquire a lock on the object that the other process has. This situation is Deadlock.
|
