We would like to implement best practice on our SQL Server instances. All of our instances still run with the default setting of MAXDOP = 0.
Having read several pages on the recommended settings for this (including Microsoft Support and Erik Darling's posts on brentozar.com), we wanted to check that we have understood these recommendations correctly in terms of our instances. All of our instances are running on virtual machines, and many have only one socket and only a handful of virtual processors.
- 1 x socket 2.30 GHz
- 6 x virtual processors
- Running 1 x SQL Server instance (2016 SP1 CU8, Web Edition 64-bit)
Change MAXDOP from 0 to 6, or from 0 to 3?
Since this instance only has a single socket anyway, a change from 0 to 6 will surely make no difference? Are we likely to gain anything from changing this setting?
- 2 x socket 2.30 GHz
- 6 x virtual processors per socket
- Running 8 x (don't ask!) SQL Server instances (2012 SP4, Standard Edition 64-bit)
Change MAXDOP from 0 to 6? Are we likely to gain anything from changing this setting?