DECLARE@SessionNameSysNameSELECT@SessionName='system_health'IFOBJECT_ID('tempdb..#Events')ISNOTNULLBEGINDROPTABLE#EventsENDDECLARE@Target_FileNVarChar(1000),@Target_DirNVarChar(1000),@Target_File_WildCardNVarChar(1000)SELECT@Target_File=CAST(t.target_dataasXML).value('EventFileTarget[1]/File[1]/@name','NVARCHAR(256)')FROMsys.dm_xe_session_targetstINNERJOINsys.dm_xe_sessionssONs.address=t.event_session_addressWHEREs.name=@SessionNameANDt.target_name='event_file'SELECT@Target_Dir=LEFT(@Target_File,Len(@Target_File)-CHARINDEX('\',REVERSE(@Target_File)))SELECT@Target_File_WildCard=@Target_Dir+'\'+@SessionName+'_*.xel'--Keepthisasaseparatetablebecauseit'scalledtwiceinthenextquery.Youdon'twantthisrunningtwice.SELECTDeadlockGraph=CAST(event_dataASXML),DeadlockID=Row_Number()OVER(ORDERBYfile_name,file_offset)INTO#EventsFROMsys.fn_xe_file_target_read_file(@Target_File_WildCard,null,null,null)ASFWHEREevent_datalike'
