June 15, 2004 at 7:05 am
I have a series of crystal reports, executing stored procedures against a 4-processor machine, in sql server standard edition.
I have turned on parallelism, to use 3 of the 4 processors, at a minimum threshold of 8, but cannot get any of these reports to use more than 1 of the processors.
Is there something I can do or something I should look at to determine if and when parallism is being used? How about something to influence parallelism?
June 15, 2004 at 1:34 pm
Do you have a high minimum query plan threshold for determining what queries recieve parallelism?
Also, have you restarted the server (or at least SQL) since you made the change?
June 15, 2004 at 1:44 pm
The default setting was 5, however, I bumped it to 8, without noticing any change.
Both Sql Server and the physical machine have been rebooted. Again without much change.
June 16, 2004 at 8:09 am
SQL Server creates and executes a parallel plan for a query only when the estimated cost to execute a serial plan for the same query is higher than the value set in cost threshold for parallelism. You need to decrease it instead of increasing it.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply