Hello all -
So, I have been hunting down and resolving deadlock issues over the past week, but have come across one that is not giving me much info in the way of the PROC or Ad-Hoc query involved. See image below
As you can see - the 'Statement:' is blank, and even the line reference is pretty vague. I've also tried reading the info from the SQL Log by using Trace Flags -T1222 and -T3605, but no luck there either. The information gives me little to no detail as to what object is the actual victim. I know that there are 2 PROCs involved, but which is the actual deadlock victim is not readily apparent, and in this particular case - the best thing I can do is look at the index given (because it is in nearly every deadlock, but my remedy for that is to simply rebuild it, and not much more - no ad-hoc query listed to add a new index by, so nothing else that I know to do).
Any insight would be much appreciated.