Monthly Archives: December 2015

Trace Deadlocks with SQL Server Profiler

Deadlocks can happen at anytime and processes compete for locks, threads, memory or other shareable resources. SQL server periodically detected deadlocks and kill one of the blocking one as victim. In many cases, we want to know the processes involved … Continue reading

Posted in Database, Tool and Debug | Tagged , , | Leave a comment