vishalsurya50 (3/15/2013)
Normally what are the causes for this type of long running re-index query ?It ran for 7 hrs.. normally it would run within 5 mins. I checked sp_who2 active and found in the Blkby column . There were blockings present in the particular database - >tables .
what process was the lead blocker?
by the way these are blocks, not deadlocks
---------------------------------------------------------------------