Archives: DBCC Trace 1222

Deadlocks in MSSQL 2005 Explained

May 1, 2012 | By kiranbadi1991 | Comments Off on Deadlocks in MSSQL 2005 Explained | Filed in: Development, Environment, Performance Engineering, Testing.

Have you ever seen the below message during your load testing assignment working in the Microsoft .Net world involving ASP.NET and MSSQL Server, Msg 1205, Level 13, State 51, Line 1 Transaction (Process ID XX) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. If • Read More »

Tags: , , , ,