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

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). This is usually a problem because after setting up these trace flags, you…

2