SQL Server MAXDOP and TempDB Recommendations for VMs

by Adrian Sugden   Last Updated May 16, 2018 13:06 PM

When configuring SQL Server on a VM does the recommendation around tempDb and MAXDOP still stand true?

TempDB - As a general rule, if the number of logical processors is less than or equal to 8, use the same number of data files as logical processors.

MAXDOP - Server with multiple NUMA nodes > Less than 8 logical processors > Keep MAXDOP at or below # of logical processors.

Recommendations and guidelines for the "max degree of parallelism" configuration option in SQL Server

I have a VM with the following and 2016 SP1 installed so my intention is to config 2 TempDb files and set MAXDOP = 2?

enter image description here



Related Questions


Multiple PVSCSI with SQL Server

Updated June 03, 2016 08:02 AM

Processor affinity for SQL Server on vmware

Updated August 29, 2017 15:06 PM

Methods for right-sizing SQL Server virtualization?

Updated April 09, 2018 23:06 PM


Single Core SQL on VM

Updated May 03, 2018 18:06 PM