Community

How to use Extended Events to proactively monitor your SQL Server for Deadlock issues

(John Daskalakis) Usually after a deadlock occurs, we don’t have the needed information to troubleshoot the deadlock issue. This is because in order to troubleshoot a deadlock issue we need verbose information, so we need to have certain trace flags enabled (e.g. 1204, 1222).

Read More - Register for Free Membership