Hi,
Recently I keep getting blocking from an application code that uses MSDTC with Serializable isolation level. The head blocked was waiting for a an Object where ID is 0, when too many of them, it caused deadlock.
How can we know what was the object since the objectID is 0 ?
<process status="running" waitresource="OBJECT: 10:0:5 " spid="98" sbid="2" ecid="0" priority="0" trancount="1" lastbatchstarted="2021-06-18T13:48:43.553" lastbatchcompleted="2021-06-18T13:48:43.550" lastattention="1900-01-01T00:00:00.550" clientapp="EntityFrameworkMUE" hostname="XXXXXXX" hostpid="15216" loginname="XXXXXXX" isolationlevel="serializable (4)" xactid="13275674392" currentdb="10" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">
<executionStack/>
Regards,
Bih Luh