Archive for 'Deadlock'
Deadlocks
SQL doctor can be used to identify the cause of deadlocks. A deadlock is when a cyclic dependency occurs between two or more threads, processes, resources, etc. This causes one of the processes to be declared the deadlock victim and killed so that the other process can continue. To identify deadlocks and provide useful information [...]
Posted: October 20th, 2010 under Deadlock, Recommendations, SDR-DL1, SDR-DL2.
Tags: Deadlocks, Improve Query Performance, Query Optimization, Query Tuning, SDR-DL1, SDR-DL2, SQL Server Performance
Comments: none
