Why job thread sleeps or late start?


I see some long thread sleep time, 40 to 50mins, in the Job Summary page. Moreover, some of the thread reports a late start time but finishes soon after that.

I’m wondering the cause of and what can I do to improve that.

Thank you so much for all the help. Below are two snippets of the two job in question.


Hello @dli16,

The long times to first start indicate that the query waited on a queue before executing. You can see in the second screenshot that the the value for “Resource Scheduling Time” is basically the same (in milliseconds) as the time to first start.

The cause of the sleep times may vary depending on the what operator you’re seeing it in. Can you attach the profile for the query in the first screenshot?