Please create a detailed deadlock report.
In addition to the existing DeadLock summary report, can you please create a DeadLock Detailed report for all deadlocks for a given time range.
Looking for a DETAILED report of deadlocks (all deadlocks for the time range) that will include:
1. Date / Time of the event
2. Blocking SPID and full query text
3. Duration of the block
3. All Child or deadlock victim SPID and full query text of the victim
Similar to the summary report, will need to be able to select the SQL server instance and / or database to report on.
Please consider creating as a CSV or Excel output with columns:
Date/Time,SQL Instance,Blocker/Victim flag,Duration,SPID,Query Text