The Max Degree of Parallelism, or MAXDOP, is one of the most known settings in the SQL Database Engine. There are guidelines of how to configure it that have intricate dependencies on the type of har...
Updated Jul 13, 2020
Version 12.0
Blog Post
Pedro, Thanks for a great article,
Since it seems this article is strictly based on general consideration and strait-forward with regards to other assumptions, it seems this is based on having SQL Server directly installed on a physical server (with no mention of virtualization), then I would like to ask, how this article would fair against Windows Server and SQL Server running virtualized (VMWare or Hyper-V) and already have hyper-threading enabled and thin-provisioned. What would be our implications on NUMA, soft-NUMA and general considerations for task scheduling?