Category Archives for "Extended Events"

Oct 12

Using Extended Events to Find Statement Causing a Job to Run Long or Hang

By Lori Brown | Extended Events , Helpful Scripts , Jobs , Performance Tuning , SQL Administration , SQL Server

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.  Since the issue only occurred intermittently, […]

Continue reading
>