How many cores for SQL Server do I need?

Question

Sold in packs of two cores, SQL Server Enterprise has a minimum requirement of 4 cores per processor or total number of cores on the server whichever is higher. If licensed without SA virtual SQL instances can be ran up to the total number of licensed Cores.

Is 4 cores enough for SQL Server?

But each sql server always has a four core minimum. Licenses for eight cores is still the same as four cores each for two sql servers. Apparently they are not concerned about the server running eight cores being overwhelmed. And I would generally agree, the four core minimum is usually sufficient.

How many cores do I need for SQL Server 2019?

A minimum of four core licenses are required for each physical processor on the server. SERVER + CAL: Provides the option to license users and/or devices, with low cost access to incremental SQL Server deployments.

How many CPU cores do I need for my server?

A general rule of thumb is to run four virtual CPU (vCPU) VMs per physical core, but again, specific workloads may have differing requirements. Don't allocate your physical cores entirely with vCPUs.

How many cores can SQL standard?

SQL Server Standard Edition is limited as to how many cores it can access: 2014 & prior cap out at 16 cores (32 with hyperthreading), and 2016 & newer cap out at 24 cores (48 with hyperthreading.)

Expert · Answer