Sql Server Standard 2019 Core Licensing [duplicate]

Solution 1:

My question though is, is it possible to get just 4 Core Licenses (on a 10 core machine) and limit Sql Server to only using those 4 cores?

• Yes. If those 4 cores are ALL CORES AVAILABLE TO THE MACHINE. Like.... running SQL Server in a Virtual Machine and this machine is limited to X virtual cores.

• NO, if the OS sees all cores - you must license the whole machine.

We're a small business, the machine serves multiple purposes.

Best practices would demand, then, that you install SQL Server in a separate VM to start with. Maintaining a system with a ton of different functions and installed things is nasty.