Hello,
I was capturing some blocking info for overnight processes. I have the info captured last night on blocking spids, dbcc inputbuffer , wait type.
Almost all the blocked SPIDs ( total 7 SPIDS ) were waiting for page 8:1:9022334 with lock type LCK_M_S.
I do not know how to find out which object the wait was happening on.
Is there any way to find out? I have reindexed the tables after this blocking info was captured in case that affects the numbers.
Thanks,
Nikki :w00t: