The query processor could not start the necessary thread resources
I having this error on my mssql server especially when there are many records inserted at the same time:
 *"100|The query processor could not start the necessary thread resources for parallel query execution."* 

i try google search the problem to upgrade my sql performance so that can avoid this error, and plenty of it suggests to set maxdrop on the query or the max degree of parallelism on the mssql. 

But how can i know how many the value of the maxdrop or max degree of parallelism i should set to? 
and how i check the maximum value of max degree of parallelism of my server can run?
if i change the max degree of parallelism of the server, means all the store proc will run following that setting, so will it affect other performance? or i just need to set the maxdrop on certain store proc?

The query processor could not start the necessary thread resources
===

I having this error on my mssql server especially when there are many records inserted at the same time:
 *"100|The query processor could not start the necessary thread resources for parallel query execution."* 

i try google search the problem to upgrade my sql performance so that can avoid this error, and plenty of it suggests to set maxdrop on the query or the max degree of parallelism on the mssql. 

But how can i know how many the value of the maxdrop or max degree of parallelism i should set to? 
and how i check the maximum value of max degree of parallelism of my server can run?
if i change the max degree of parallelism of the server, means all the store proc will run following that setting, so will it affect other performance? or i just need to set the maxdrop on certain store proc?
