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

**abodineau** · 09-30-2010, 02:19 AM

Hi
I use SQL Server 2008 and in the past hour or so I've kept getting this error message:
"The query processor could not start the necessary thread resources for parallel query execution."

A quick search in Google tells me that this is because the SQL server is busy. Is it possible to fix this at your end (having fewer databases per server) or checking how busy each database is, making sure that each database doesn't use too much server ressources, etc?

Right now my website is hardly usable and my visitors keep getting the above error message (well, a user-friendly is shown to them instead) and they can't do anything with the site.

Regards,
Anthony Bodineau.

**abodineau** · 09-30-2010, 07:09 AM

Anyone? I've had this problem for hours now. I'm hardly using my database now and i keep getting this error message "The query processor could not start the necessary thread resources for parallel query execution." which means the server is busy. As a result my website is hardly usable. Is it possible for you to check which database is using all the ressources?
The server I use is: sql2k801.discountasp.net

**bruce** · 09-30-2010, 10:48 AM

I never seen this error before. I checked the monitoring system and the server seems to be healthy.

I recommend you open a support ticket if you continue to see this problem.

**abodineau** · 10-01-2010, 02:29 AM

I opened a support ticket and the answer was that I would be "directed to the system administrators."...

When you monitor the system do you keep a log? If so you should see the error message that I got in the log of this server: sql2k801.discountasp.net

This probably lasted for a few hours yesterday but bythe time you checked everything was back to normal.

If this problem occured because some of the other customers are over-using their database on the same server as mine (sql2k801.discountasp.net) then we need to know as it's very likely to happen again and very frustrating for those affected by it.

**abodineau** · 10-01-2010, 08:30 AM

I have the same problem again. As soon as I execute a stored procedure I get this error message 'The query processor could not start the necessary thread resources for parallel query execution.' which means the server is busy.

Can someone look into this? My website is unusable in the meantime. This is critical to me. If it cannot be fixed then I will have to move my website to a different web hosting company. I just can't wait.

+Support doesn't reply back to my tickets which is really not a good sign.

**bruce** · 10-01-2010, 11:30 AM

This is so weird.. i checked the helpdesk and I do not see a single ticket complaining about the server besides your ticket.

The monitoring system simply monitor CPU / Memory and execute a simple query on the master database. It reported no outage nor latency.

**bruce** · 10-01-2010, 11:31 AM

I think our DBA is already looking into this.

09-30-2010, 02:19 AM	#1
abodineau Join Date: Jan 2008 Posts: 38	The query processor could not start the necessary thread resources for parallel query Hi I use SQL Server 2008 and in the past hour or so I've kept getting this error message: "The query processor could not start the necessary thread resources for parallel query execution." A quick search in Google tells me that this is because the SQL server is busy. Is it possible to fix this at your end (having fewer databases per server) or checking how busy each database is, making sure that each database doesn't use too much server ressources, etc? Right now my website is hardly usable and my visitors keep getting the above error message (well, a user-friendly is shown to them instead) and they can't do anything with the site. Regards, Anthony Bodineau.

09-30-2010, 10:48 AM	#3
bruce DiscountASP.NET Staff Join Date: Jan 2003 Posts: 6,501	I never seen this error before. I checked the monitoring system and the server seems to be healthy. I recommend you open a support ticket if you continue to see this problem. __________________ Bruce DiscountASP.NET

10-01-2010, 11:30 AM	#6
bruce DiscountASP.NET Staff Join Date: Jan 2003 Posts: 6,501	This is so weird.. i checked the helpdesk and I do not see a single ticket complaining about the server besides your ticket. The monitoring system simply monitor CPU / Memory and execute a simple query on the master database. It reported no outage nor latency. __________________ Bruce DiscountASP.NET

10-01-2010, 11:31 AM	#7
bruce DiscountASP.NET Staff Join Date: Jan 2003 Posts: 6,501	I think our DBA is already looking into this. __________________ Bruce DiscountASP.NET

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

09-30-2010, 07:09 AM	#2
abodineau Join Date: Jan 2008 Posts: 38	Anyone? I've had this problem for hours now. I'm hardly using my database now and i keep getting this error message "The query processor could not start the necessary thread resources for parallel query execution." which means the server is busy. As a result my website is hardly usable. Is it possible for you to check which database is using all the ressources? The server I use is: sql2k801.discountasp.net

10-01-2010, 02:29 AM	#4
abodineau Join Date: Jan 2008 Posts: 38	I opened a support ticket and the answer was that I would be "directed to the system administrators."... When you monitor the system do you keep a log? If so you should see the error message that I got in the log of this server: sql2k801.discountasp.net This probably lasted for a few hours yesterday but bythe time you checked everything was back to normal. If this problem occured because some of the other customers are over-using their database on the same server as mine (sql2k801.discountasp.net) then we need to know as it's very likely to happen again and very frustrating for those affected by it.

10-01-2010, 08:30 AM	#5
abodineau Join Date: Jan 2008 Posts: 38	I have the same problem again. As soon as I execute a stored procedure I get this error message 'The query processor could not start the necessary thread resources for parallel query execution.' which means the server is busy. Can someone look into this? My website is unusable in the meantime. This is critical to me. If it cannot be fixed then I will have to move my website to a different web hosting company. I just can't wait. +Support doesn't reply back to my tickets which is really not a good sign.