When two sessions are blocked by each other and waiting for a resource which is locked, Deadlock arises in the Database System. Internally, SQL Server detects those two sessions and makes one as a Deadlock victim. After that, it rolls back the victim session and returns the deadlock error message to the client. It releases … Continue reading SQL Server: What happens after the Deadlock arise?