We are running a Dynamics AX production on SQL Server 2008 R2, recently one of Microsoft consultants tested our production and suggested to set Max degree of parallelism option to 8, But Microsoft Dynamics AX Best Practice suggests Parallelism to 1! (Planning database configuration for Microsoft Dynamics AX.pdf)
AX database is running on a dedicated server with 2 Physical processors (Xeon E-7) with 8 cores each.
I am confused with these two options. If I set as 1, then Database cannot use full power of multi-processing!
Please suggest best configuration settings for Dynamic AX SQL server 2008 R2 Production.