May 7, 2018 at 11:40 am
I want to set the MaxDOP correctly on a new SQL 2017 server. I'm looking at this article on Brent Ozar's site:
https://www.brentozar.com/archive/2013/09/five-sql-server-settings-to-change/
My infrastructure guy is telling me the VM is configured as 4 single-core CPUs. So, I'm understanding I should set MaxDOP=1. Am I reading this correctly?
Would it be of any benefit to change the VM to use 1 CPU with 4 cores and then set MaxDOP to 4?
May 7, 2018 at 2:34 pm
There is no one correct answer, especially for VM. But for 4 VCPU you can safely start with maxdop=2 and Cost Threshold For Parallelism=30 and go up with Cost Threshold For Parallelism if needed. The worst what you can do is to leave this settings as default.
Also don't forget that SQL Standard can't run on more than 4 sockets so if you going to add additional VCPU to VM in future, add cores not sockets.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply