I query system_health ee file and filter on just xml_deadlock_report.
under "/event/data/value/child::*" I'm finding a deadlock graph.
<deadlock> <victim-list /> <process-list>
No victim. Nothing dies. Nobody kills a process. The processes all compete.
This only happens on my 2017 instance. The 2016 instances only show deadlocks with a victim.
My assumption is that this is showing blocking and the waiting caused and that this is new in 2017.
Am I making the correct assumption or am I missing something?
-- Adding resource-list
These are both threads of the same query
<resource-list> <exchangeEvent id="Pipe28858c12690" WaitType="e_waitPipeNewRow" waiterType="Producer" nodeId="16" tid="1" ownerActivity="receivedData" waiterActivity="tryToSendData" merging="true" spilling="false" waitingToClose="false"> <owner-list> <owner id="process288aa523c28" /> </owner-list> <waiter-list> <waiter id="process285fc5fc8c8" /> </waiter-list> </exchangeEvent> <exchangeEvent id="Pipe286af65e8b0" WaitType="e_waitPipeNewRow" waiterType="Producer" nodeId="4" tid="1" ownerActivity="receivedData" waiterActivity="tryToSendData" merging="true" spilling="false" waitingToClose="false"> <owner-list> <owner id="process285fc5fcca8" /> </owner-list> <waiter-list> <waiter id="process288aa523c28" /> </waiter-list> </exchangeEvent> <exchangeEvent id="Pipe286af65fe80" WaitType="e_waitPipeGetRow" waiterType="Consumer" nodeId="4" tid="1" ownerActivity="sentData" waiterActivity="needMoreData" merging="true" spilling="false" waitingToClose="false"> <owner-list> <owner id="process285a442aca8" /> </owner-list> <waiter-list> <waiter id="process285fc5fcca8" /> </waiter-list> </exchangeEvent> <exchangeEvent id="Pipe28549b18e90" WaitType="e_waitPipeGetRow" waiterType="Consumer" nodeId="16" tid="2" ownerActivity="sentData" waiterActivity="needMoreData" merging="true" spilling="false" waitingToClose="false"> <owner-list> <owner id="process285fc5fc8c8" /> </owner-list> <waiter-list> <waiter id="process285a442aca8" /> </waiter-list> </exchangeEvent> </resource-list>