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

Question

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 1

The problem indicates that your SQL server threads are already busy and unable to allocate any other threads to handle your request. You can also try to enable MARS (Multiple Active Result Sets) option in the connection string by setting it "MultipleActiveResultSets=true" if you're executing multiple batches.

Answer 2

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