One of my company's SQL database generates a lot of deadlocks per day recently (someday >100)

I'm trying to troubleshoot the causes of these deadlocks, i noticed that many deadlocks occur at the same tables, I'm a newbie in Database Administrator so i don't know what can be infer from these reports and what to do next.

Also what is the best way to do some statistics on the deadlock reports, like i want to calculate and visualize things like what tables involed, how manytimes, what time the deadlocks usually happen.... so i can report to my boss, is there an easy way to import the all the deadlock xml columns to something like microsoft excel?

I attached here the deadlock reports (.xel file) Deadlocks_reports

Sorry for english is not my first language.

Thank you for your time,

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.