February 4, 2005 at 5:11 am
Hi, i'm very new to performance issues with SQL server but i cant understand how to get(or whether i should) my SQL server to use all processor when processing queries. I ran an intense query that would work the server hard and it returned the results in 27 mins but i was watching the performace monitor and it was only using 1 of four processors. if it were to use all 4 surely it would be quicker.......wouldn't it??? I have tried reducing the parallelism settings to use a minimum query plan threshold of 0 but that doesn't seem to have made any difference. Can anyone tell me whether this is normal and if not how i can configure my server to be more efficient?
Hope this is clear
Dan
February 4, 2005 at 9:05 am
SQL Server will dynamically decide on the resources available whether to use an execution plan in parallel or not. Can you check the value for max degree of parallelism parameter by running sp_configure ? This should be 0.
February 7, 2005 at 6:37 am
Hi thanks for the reply. I have run sp_configure and my min is set at 0 but my max is set at 32. What does this mean and where is this setting configured from?
Dan
February 8, 2005 at 1:57 pm
min = 0 means dynamic allocation. max =32 is the max. no. of processors that SQL Server supports. your run_value should be set to 0 in your case.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply