SQL 2008 R2 "Parallelism" setting

[tjandra_afandi2]

Hi, could anybody advise me on what's the best practice on setting the "Parallelism" properties? (Server Proterties --> Advanced --> Parallelism)

FYI here's the setting we have:

• Cost Threshold for Parallelism: 5
• Locks: 0
• Max Degree of Parallelism: 1
• Query Wait: -1

Also FYI our server has dual processor (Xeon E5-2695 v2 @ 2.40GHz) with total 24 cores.

NOTE: for some reason that I can't remember what the exact problem was, we set "Max Degree of Parallelism" to 1. Something related to locks/long processings...

Thanks.

[tjandra_afandi2]

I found the page that "advised" us to use MAXDOP = 1:

http://www.sqlskills.com/blogs/paul/maxdop-configuration-survey-results/

[frank_wang6]

https://msdn.microsoft.com/en-us/library/ms189094(v=sql.105).aspx

You should set to 0 to use all possible cores on ur server.

Frank

[tjandra_afandi2]

According to this, it's best not to use 0... (EDIT: sorry I think i read it wrong... it says 0 can lead to performance issue)

http://www.javedqureshi.com/performance-practices-sap-business-one-landscape/