On one of the servers that we monitor, it was reported that periodically a specific job would seem to hang and take forever to complete. I was asked to set up something to help find exactly what statement in the job that was the root cause of the hang.
Read on to see how Lori was able to collect the info necessary to resolve this issue.