We've got a db that has been pretty much deadlock free for over 6 months, but a day or two ago we had over 60, all on the same two or three pages of the same table (~12,000,000 rows, ~250 bytes per row.)
From the deadlock graph I can see what pages are common in all the deadlocks, and part of the query that was running (always an
INSERT vs a
SELECT) but I have no idea what rows or data this involves. Is there any way to find out?