If the monitor detects a cyclic dependency, it chooses one of the tasks as a victim and terminates its transaction with an error. the SQL Server Database Engine deadlock monitor periodically checks for tasks that are in a deadlock. ![]() This condition is also called a cyclic dependency: Transaction A has a dependency on transaction B, and transaction B closes the circle by having a dependency on transaction A.īoth transactions in a deadlock will wait forever unless the deadlock is broken by an external process. Transaction A cannot complete until transaction B completes, but transaction B is blocked by transaction A.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |