I am looking at a deadlock graph. Hover over 1st process shows me a sql doing a SELECT on TableA.
SELECT COL1, COL2 FROM TableA
Hover over 2nd process shows me a sql doing update on TableB.
(@P1 text) UPDATE TableB SET COL1=10, COL2=@P1 WHERE COL3=100
The 2 rectangles in the middle show me the resource (page lock) is on TableB.
Why is the 1st process showing TableA SQL and pointing to rectangle containing resource TableB?