Previous releases of SQL Server performed deadlock checking when the process began to wait for a lock. In release 11.0, SQL Server performs deadlock checking for a process only after it has waited a minimum of 500 ms. for a lock to be released. To return to the previous way of deadlock checking, set deadlock checking period to 0.
