SQL Server 2008 R2: query RECENT locks, NOT current locks The database had average lock wait time of 30 seconds for a period of about a minute.
I didn't run my lock query in time to see what was happening.
I can't seem to find anything that shows recent locks, just current locks.
some (most) X locks are recorded in the log, see How to read and interpret the SQL Server log. You can see what xact acquired them and how long the xact lasted (see the link). You won't find the conflicts, but you can make some guess.