Tag Info

New answers tagged


An easier way to understand a deadlock graph is taking that information you have and saving it as a .xdl file. That is the default deadlock graph file extension. Then you can open it with either SSMS or SQL Sentry Explorer. With the graph you will have a quicker understanding on what happened, which process was waiting, which one was blocked, which resource ...


I'll repost my response on twitter here: Based on the deadlock XML you posted, which lists a trancount of 3 in the session that invokes spUpdateUserAccount, a prior statement or batch in that transaction likely put the lock on IX_Person_TaxPreparer_rowCreated. I'm presuming this lock is held because of the foreign key constraint in place. The locks are ...

Top 50 recent answers are included