I notice whenever there is corruption in a single extended events deadlock report …
… sp_BlitzLock would not work at all …
Msg 9411, Level 16, State 1, Procedure sp_BlitzLock, Line 185 [Batch Start Line 12]
XML parsing: line 37, character 166, semicolon expected
My work-around was to replace line 196 …
AS ( SELECT CONVERT(XML, event_data) AS deadlock_xml
… with this …
AS ( SELECT CONVERT(XML, REPLACE(event_data,'&',';')) AS deadlock_xml
Database Consultant 