• If you are still using 2005 and don't have Xevents, you could also use profiler. Brad McGehee has an excellent article here:

    https://www.simple-talk.com/sql/sql-tools/how-to-identify-blocking-problems-with-sql-profiler/

    Fraggle