Tag Archives: trace sql server deadlock

Deadlock Analysis – READ Deadlock from SQL ERRORLOG

How to read DEADLOCK Information in SQL Server ERRORLOG ? In our previous posts, we learned how to trace dead lock information in SQL Server Errorlog. Once the this information is logged inside SQL Server Logs, then how can we use that information for deadlock analysis. In case you want to build your test scenario [...]

How to trace Deadlock in SQL Server ?

What is a DEAD LOCK in SQL Server? When two or more transactions conflict in such a way that each is waiting for the other before they proceed. For instance, Transaction A might have a lock on Record 1 while trying to write to Record 2, while Transaction B has a lock on Record 2 [...]