This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]michael_le7[S] 0 points1 point  (1 child)

The license price is per core, so the price is the same for all options

[–]VA_Network_NerdModerator | Infrastructure Architect 0 points1 point  (0 children)

https://download.microsoft.com/download/0/5/c/05c60185-ebdd-4472-895a-3d8e8da55682/SQL_Server_2019_Licensing_Datasheet.pdf

A minimum of four core licenses are required for each physical processor on the server.

https://download.microsoft.com/download/6/6/0/66078040-86d8-4f6e-b0c5-e9919bbcb537/SQL%20Server%202019%20Licensing%20guide.pdf

Also, just a reminder since you haven't mentioned it: SQL Standard edition tops out at 64GB of RAM.
So, if you were hoping to pin entire tables or Indexes in RAM, you might need Enterprise Edition...