October 1, 2010 at 7:58 am
Hi All,
This is something I've never seen before so I was hoping to see if maybe one of you may be familiar with the cause of this exception in SQL Server 2008 R2.
/**********************************************
The query processor could not start the necessary thread resources for parallel query execution.
**********************************************/
Is there one particular wait type I should investigate further to help me find this answer. Again, this is the first time I've seen this type of exeption in our environment.
Thanks for the help!
😀
October 1, 2010 at 9:02 am
[edit]: Looks like this is answered in the original thread http://www.sqlservercentral.com/Forums/Topic996602-391-1.aspx
I've never seen this error but the documentation states that this happens due to workload on the server
http://msdn.microsoft.com/en-us/library/aa337448.aspx
The only "resolution" available is to reduce the workload on the server (and if possible capture information about resource usage so that you might be able to figure out why this is occuring).
Don't know which wait types might help here - you could try looking at the CPU related perfmon counters (things like processor queue length , processor time etc) and see if they provide any info
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply