Deadlock is a situation when two
processes, each having a lock on one piece of data,
attempt to acquire a lock on the other's piece. Each
process would wait indefinitely for the other to
release the lock, unless one of the user processes is
terminated. SQL Server detects deadlocks and terminates
one user's process.
Check out SET DEADLOCK_PRIORITY and "Minimizing
Deadlocks" in SQL Server books online. Also
check out the article Q169960 from Microsoft knowledge
base.
No comments:
Post a Comment