why deadlocks cannot be automatically handled by the lock monitor

Why would sql-server lock monitor thread would not resolve deadlocks?

I don't have much details about this, but my friends complain about deadlocks occuring from time to time on SQL Server (2005 & 2008) databases.

As I know, Sql Server deadlock detection mechanism handles deadlock scenarios pretty well by choosing one of the processing as the victim and terminating/rolling it back, so the other process can complete, so no deadlocks would be left there to resolve.

Are there any conditions where SQL Server deadlock handling might fail, or it mig开发者_如何学编程ht be turned off?

thanks in advance

---

Deadlock handling can only result in one connection being killed.

This is the only resolution to a deadlock sitution, which happens when 2 process are blocking each other. So neither can proceed and one must be aborted