The Deadlock report lets you analize analyze deadlocks on your SQL Server instance.
By analyzing the deadlocks, you can better determine where deadlocks are occurring and analyze the changes can have the greatest performance impact.
The report filters the data by Instance Name, followed by Application Name, Database Name, SQL Statement, Collection Date, XDL Data, Deadlock ID, Login Name, and Host Name.
This report lists all the deadlock occurrences historically and in detail.
When to run this report
By analyzing the deadlocks, you can better determine where deadlocks are occurring and analyze the changes can have the greatest performance impact.