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

from 

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/1901f6e1-2dc3-4763-874d-d5420345eb3f/processor-could-not-start-the-necessary-thread-resources-for-parallel-query-execution?forum=sqldatabaseengine

 

You should change the SQL Server's "Max degree of parallelism" setting from 0 (default) to a number not greater than number of cores/threads in one NUMA node of your server.

Easy way to know that number is to divide the number of cores/threads by the number of NUMA nodes. You can get the number of cores and NUMA nodes from Windows's Task manager on the Performnace tab. You'll see the total number of cores if you select option "One graph per CPU" on the "View" - "CPU history" menu, while switching this option to "One graph per NUMA node" will give you the number of NUMA nodes your system have. This is correct for Windows Server 2008 R2.

Or you can get the number of NUMA nodes from you server h/w specifications.

If Task manager is not showing the "One graph per NUMA node" option then you probably have only one NUMA node and this not your case.