Jamie Wick helps us figure out what’s causing deadlocks:
Recently I started getting random alerts that a job on one of the SQL servers was failing because of a deadlock problem.
The source of the problem wasn’t immediately discernible as there wasn’t any pattern to when the job was failing. Troubleshooting was further complicated by the database being written/maintained by a 3rd party vendor that encrypts all of their stored procedures.
So… How to find out what was causing the deadlock?
Extended Events are an ideal solution for this situation.
Read on to learn how.