December 2, 2005 at 9:31 am
We are taking over an application from a third party vendor and they have configured the processor tab of SQL Server in the following manner:
SQL Server can use all available processors but only one processor can be used for parellel execution of queries.
I am trying to find some information that would determine why you would choose this configuration. Does anyone have any thoughts?
Thanks!!
December 2, 2005 at 2:59 pm
Parallel execution plan sometimes really hurts the performance. I encountered several times that the parallel plan was more than 10 times slower for the same query. Once it even hang there (that's in the old time of SQL server 2000+SP2 ).
So if your database has lots of concurrent calls, disable parellel execution of queries is a valid option. SQL server can use different CPUs to response different users concurrently.
Another option is to chnage the max parellel degree and the cost thresh hold value for parallelism. However, MS usually does not recommend doing this.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply