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.

Answer 1

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

Answer 2

Thanks Arthur