2016 | OriginalPaper | Chapter
19. Deadlocks
Published in:
Pro SQL Server Internals
Abstract
A deadlock is a special blocking case when multiple sessions, or sometimes multiple execution threads within a single session, block each other. When it happens, SQL Server terminates one of the sessions, thus allowing others to continue.