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...