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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » ERROR : The query processor could not start...

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

Rate Topic

Display Mode

Topic Options

Author

Message

charipg

Posted Sunday, June 06, 2010 6:16 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, May 16, 2013 12:43 AM
Points: 378, Visits: 897

job failed due to below error.

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

how to resolve this?

I have checked in the server, there in no blocking and cpu usage is very low.

Post #933217

charipg

Posted Sunday, June 06, 2010 8:14 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, May 16, 2013 12:43 AM
Points: 378, Visits: 897

any help on this?

Post #933230

ashish 10950

Posted Monday, June 28, 2010 5:55 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, January 27, 2011 6:38 AM
Points: 18, Visits: 76

I was looking at your problem and what i found out was heavy utilization of the server . Here is something from pinal dev and Amit Pandey , please see if it is helpful .
http://blog.sqlauthority.com/2008/01/30/sql-server-fix-error-the-query-processor-could-not-start-the-necessary-thread-resources-for-parallel-query-execution/

Post #943818

« Prev Topic | Next Topic »

Permissions