James Synge wrote:
I'm trying to debug a deadlock, and would like to better understand the names of the locks involved. For example:Yes this indicates a ROW level lock on BUILD_REQUEST at page and row number (11,1)ROW, BUILD_REQUEST, (11,1)My guess is that this means that I'm dealing with a lock on a row in the BUILD_REQUEST table, and that it is probably row 1 in block (or page?) 11. Can anyone confirm this?Thanks, James