Fellow SQL dBAa,
I am trying to understand the difference between the MODE values in the XML dump.
I have solved the deadlock but trying to understand why it displayed a certain way in the graph or even shows what it does in the XML.
User 1 had an exclusive lock on table A - which was for an update. User 2 wanted a shared lock on table A for a Select (The select was reading table A and B).
User 2 had a shared lock on table B for a select (believe to be same select as above). User1 wanted an exclusive lock on table B and, if it got it, was going to do an update.
In the xml, when I look at resource section, I see a keylock with MODE of U but a U does not appear on the Modes for the two connections/processes - one has an S and one has an X.
What makes the MODE on the keylock lines different then the owner line and waiter line? Neither of those had a U.
thx
MG