• SPID 69 is updating Status table while SPID 77 is selecting the same table.

    SPID 69 is holding IX lock on page 5:3:695694 and trying to lock (IX) another page (5:3:695693).

    In the meantime, SPID 77 is holding S lock on 5:3:695693 and trying to put S lock on next page 5:3:695694.

    Hence the deadlock.