The query processor could not start the necessary thread resources for parallel query execution

c# multithreading resources processor
MonsterMMORPG picture MonsterMMORPG · Oct 17, 2011 · Viewed 36.4k times · Source

What does this mean and how to solve.

I am running multi threaded c# application and this error happens when accessing database.

The query processor could not start the necessary thread resources for parallel query execution.

I am using "using statements" at every query so i suppose connections are getting disposed of after used.

How can i monitor what is causing this ? This is starting happening after some time like at least after 1 hour.

Windows 7 64 bit sp1 16 gb ram visual studio 2010 mssql 2008 r2 core i7 2600 @ 4.5 ghz

Answer

Adrian Carr picture Adrian Carr · Dec 6, 2013

There is a much better answer with more discussion and details over at dba.stackexchange.com.

https://dba.stackexchange.com/questions/47237/need-to-understand-parallel-query-execution-error

Related questions

How do I update the GUI from another thread?

Which is the simplest way to update a Label from another Thread? I have a Form running on thread1, and from that I'm starting another thread (thread2). While thread2 is processing some files I would like to update a Label …

Read More
How do I run a simple bit of code in a new thread?

I have a bit of code that I need to run in a different thread than the GUI as it currently causes the form to freeze whilst the code runs (10 seconds or so). Assume I have never created a new …

Read More
Cross-thread operation not valid: Control accessed from a thread other than the thread it was created on

I have a scenario. (Windows Forms, C#, .NET) There is a main form which hosts some user control. The user control does some heavy data operation, such that if I directly call the UserControl_Load method the UI become nonresponsive …

Read More