camo
Active Member
I recently came across a recommendation to set the SQL Server option "Max degree Of Parallelism" to 1 for installations of JDE. The default in our new SQL 2005 installation is a value of 0.
SQL 2005 Books Online state the following for this option:
"Limits the number of processors (up to a maximum of 64) to use in parallel plan execution. The default value of 0 uses all available processors. A value of 1 suppresses parallel plan generation."
We are on EnterpriseOne 8.12 with TR 8.96_H1
Our database server is dual processor, and it seems like a waste to not let SQL make the most of this.
Anyone have any thoughts / recommendations ?
Thanks in anticipation.
SQL 2005 Books Online state the following for this option:
"Limits the number of processors (up to a maximum of 64) to use in parallel plan execution. The default value of 0 uses all available processors. A value of 1 suppresses parallel plan generation."
We are on EnterpriseOne 8.12 with TR 8.96_H1
Our database server is dual processor, and it seems like a waste to not let SQL make the most of this.
Anyone have any thoughts / recommendations ?
Thanks in anticipation.