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 [...]
Tag Archives: sql server deadlock trace flags
Deadlock Analysis – READ Deadlock from SQL ERRORLOG
Posted by Mahesh Gupta on February 24, 2012
0 comments
How to trace Deadlock in SQL Server ?
Posted by Mahesh Gupta on December 29, 2010
0 comments
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 [...]
