SQL Server Performance Analysis-SQL statements used to query deadlocks

-- Query deadlocks and blocked SQL statements

Select cast (replace (xeventdata. xevent. Value ('(data/value) [1]',
'Varchar (max )'),
'<Victim-List>', '<deadlock> <victim-List> '),
'<Process-List>', '</victim-List> <process-List>') as XML) as deadlockgraph
From (select cast (target_data as XML) as targetdata
From SYS. dm_xe_session_targets St
Join SYS. dm_xe_sessions s on S. Address = ST. event_session_address
Where [name] = 'System _ health'
) As Data
Cross apply targetdata. nodes ('// ringbuffertarget/event') as xeventdata (xevent)
Where xeventdata. xevent. Value ('@ name', 'varchar (8000)') = 'xml _ deadlock_report ';