Waiting for worker thread

  • I have been running into a problem late where almost every morning jobs are waiting to execute due to “Waiting for Worker thread”. I don’t fully understand why this is happening? Right now (8:38am central) we have 13 jobs waiting, but only 119 spids running. From looking online it says one problem may be the Max worker threads needs to be raised. However, I have raised it from 255 (default) to 300 (and performed a restart awhile back) and that does seem to have fixed anything. Anything you can do to help me would be greatly appreciated. We are on SQL Server 2000 version.

  • You have resource issues. Worker Threads should stay at 255 unless you get direction from PSS to change it. I'd call PSS and work through this issue with them.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply