Is there a way to identify processes that were blocking or were blocked by another process after the fact without setting something up ahead of time?
My weekly maintenance job (rebuild indexes, update stats) ran extremely long. I'm thinking that it was trying to work on something and encountered blocking to prevent it from continuing, but I don't know what that might be.
Thanks!