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,