Error: System.Data.SqlClient.SqlException: "The query processor could not start the necessary thr (4307183)

In Archive Manager, you may have issues with your Full Text Index where you see an error in the Full text Indexlogs that is as follows:

System.Data.SqlClient.SqlException: The query processor could not start the necessary thread resources for parallel query execution.

You may get an error about the query processor in SQL not being able to start the necessary thread resources for parallel query execution, when you have The SQL Server configuration option 'max degree of parallelism' set to high for the amount of processors you have on the SQl server

The SQL Server configuration option 'max degree of parallelism' controls the number of processors used for the execution of a query with a parallel plan. This option determines the computing and thread resources used for the query plan operators that can perform the work in parallel. Depending upon whether SQL Server is setup on a Symmetric MultiProcessor Computer [SMP], Non-Uniform Memory Access computer [NUMA] or HyperThreading enabled processors, you will need to configure the 'max degree of parallelism' option appropriately.

As per Microsoft please use the following guidelines for SQL Server 2008 R2, SQL Server 2008 and SQL Server 2005 servers.

a. For servers that have eight or less processors, use the following configuration where N equals the number of processors: max degree of parallelism = 0 to N .
b. For servers that use more than eight processors, use the following configuration: max degree of parallelism = 8.
c. For servers that have NUMA configured, max degree of parallelism should not exceed the number of CPUs that are assigned to each NUMA node with the max value capped to 8. This will increase the likelyhood of all parallel threads of a query to be located within a NUMA Node and avoid costly remote node data look ups.
d. For servers that have hyper-threading enabled, the max degree of parallelism value should not exceed the number of physical processors.

For more information please check the microsoft site at http://support.microsoft.com/kb/2023536