Jody Davis
asked on
How much is SQL Enterprise regarding physical/virtual CPU usage?
I want to do some work that states it needs SQL Enterprise. I would think either SQL2012 or SQL2016. The task is irrelevant. I know it is more expensive than SQL Standard. We use VMware on blade servers that have numerous physical Intel CPUs and of course have hyperthreading. I know MS changed their licensing not long ago.
Let's say (to keep numbers round) i want to assign 10vCPUs to this new SQL2012/2016 VM. If my blade server happens to have 20 physical sockets with hyperthreading enabled, how would MS charge me for that VM? If - let's say just to make it easy - MS charged $100 per whatever Ent SQL metric they now use to charge for SQL - how much would that cost me? These are notional amounts, but you understand what i'm asking. How much would this situation cost me with those make-believe numbers - so i can then take that process and apply it to my real-world hardware/software?
If you would be so kind, please try and provide the notional $$ amount and a link for actual info as well. This is a side-project and was hoping not to investigate too much - time wise :)
Let's say (to keep numbers round) i want to assign 10vCPUs to this new SQL2012/2016 VM. If my blade server happens to have 20 physical sockets with hyperthreading enabled, how would MS charge me for that VM? If - let's say just to make it easy - MS charged $100 per whatever Ent SQL metric they now use to charge for SQL - how much would that cost me? These are notional amounts, but you understand what i'm asking. How much would this situation cost me with those make-believe numbers - so i can then take that process and apply it to my real-world hardware/software?
If you would be so kind, please try and provide the notional $$ amount and a link for actual info as well. This is a side-project and was hoping not to investigate too much - time wise :)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>If my blade server happens to have 20 physical sockets with hyperthreading enabled, how would MS charge me for that VM?
They would buy the server off you and sell it to a blade server manufacturer to clone it, Did you mean 20 cores?
They would buy the server off you and sell it to a blade server manufacturer to clone it, Did you mean 20 cores?
ASKER
Using the SQL server pricing list for 2017 from the link you provided, Andrew - am i right in saying if i wanted to create a VMware VM and install SQL server 2017 and have 2-VMware vCPUs for the VM - the cost for that server for just SQL alone would be over $14k?
RRP is over $14k, you may get a discount. May be better to sort through your blades to see if you have a dual-core one and use that, at least you could turn hyper-threading on to get 4 virtual cores at the same price.
ASKER
Thanks guys, more than i wanted to pay for. but this is what i needed to know.
Since you wanted to calculate the rough amount, sharing some unofficial license cost calculators..
Enterprise Edition
https://wintelguy.com/mssql-ent-licensing-calc.pl
Standard Edition
https://wintelguy.com/mssql-std-licensing-calc.pl
Another website, with SA costs included..
https://www.sqlgovernor.com/en/calculator/