Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SQL 2008 R2 "Parallelism" setting

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.

Not what you were looking for? View more on this topic or Ask a question