A good article, that with a thorough proof read would have resulted in a very good article.
11757457 ObjID is actually the ID for the Bibby.Profit_Act table. 1:153:1 is the first row in the Bibby.Profit_Act table. The interesting thing to note is the X lock has been granted on this first row, but the transaction goes into a waiting state when it tries to lock the second row as well which is 1:153:1 (Note the Status column showing ‘WAIT’ status) for the update lock being requested.
11757457 - Should be 117575457
1:153:1 is the first row - should be 1:153:0 is the first row
It was easy for me to catch these mistakes (But I knew this topic already).
Also an explanation of the lock resource values and how to understand how you know that
1:153:0 is the first row would have been appreciated.
DatabaseID:FileID:PageID:Slot(row) or FileID:PageID:Slot(row)