none
Parallel query exeuction

    Question

  • I am getting the error

    The query processor could not start the necessary thread resources for parallel query execution. How do I resolve this issue.

    Wednesday, May 02, 2012 5:37 PM

Answers

  • This is typically caused by an excessive workload, specifically SQL Server was too busy processing other requests, so unless the issue is repeating itself too often (then you need to look into the root cause which typically ends with adding resources and/or fixing bad queries, etc.) there is nothing much to do here.

    Arthur My Blog

    • Marked as answer by Nibras33 Wednesday, May 02, 2012 5:51 PM
    Wednesday, May 02, 2012 5:41 PM

All replies

  • This is typically caused by an excessive workload, specifically SQL Server was too busy processing other requests, so unless the issue is repeating itself too often (then you need to look into the root cause which typically ends with adding resources and/or fixing bad queries, etc.) there is nothing much to do here.

    Arthur My Blog

    • Marked as answer by Nibras33 Wednesday, May 02, 2012 5:51 PM
    Wednesday, May 02, 2012 5:41 PM
  • Thanks Arthur
    Wednesday, May 02, 2012 5:53 PM