search

MicrosoftDocs / azure-docs

Open source documentation of Microsoft Azure
https://docs.microsoft.com/azure
Creative Commons Attribution 4.0 International
10.22k stars 21.38k forks source link

Pricing for cost effective SQL VMs #7032

Closed stigra closed 6 years ago

stigra commented 6 years ago

Where is it possible to find pricing for cost effective SQL VMs? I am unable to find these on the pricing page and in the Azure calculator.

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

mimckitt commented 6 years ago

@stigra Thanks for the feedback! We are currently investigating and will update you shortly.

mimckitt commented 6 years ago

@stigra are you referring to if you use the BYOL or the free version? If so, you just pay for the price of the VM. So in the pricing calculator it gives your the price with just the OS or with SQL license

image image
stigra commented 6 years ago

My understanding of the core constrained VMs is that the compute cost is the same as for the non-constrained version (i.e. compute for E64-16s = E64s),right? However SQL licensing will be reduced accordingly to the available cores . Is this only applicable for BYOL licenses or will SQL licensed through Azure also be reduced accordingly? If this applies BYOL only then it should be made clearer in the documentation as you can get the impression that it applies to VM licensing as well.

mimckitt commented 6 years ago

@stigra got it. Thanks for clarifying the ask.

@rothja is this something you are able to shed some light on?

rothja commented 6 years ago

@stigra Thanks for the licensing question. Your understanding is correct, the compute cost is the same but the SQL licensing cost is reduced because of constrained cores (good for SQL workloads that need the increased memory and other specs but not the extra cores). This applies to BYOL and SQL pay-as-you-go licensing.

Unfortunately, the pricing calculator does not yet reflect these new options. I'll follow up with the product team again to ask them to get this fixed soon. They were working on it last time I talked to them about it. I'm sorry for the confusion.

rothja commented 6 years ago

please-close

mimckitt commented 6 years ago

@rothja would you happen to have any update on this?

We had a customer reach out via MSDN noticing the changes are still not reflecting in the pricing calculator

https://social.msdn.microsoft.com/Forums/en-US/218d83f7-4f80-4868-9c1b-9abf905e090b/why-do-core-constrained-sql-server-vms-cost-same-as-unconstrained?forum=windowsazurepurchasing

rothja commented 6 years ago

@MicahMcKittrick-MSFT The last I heard was that it was being worked on. I sent mail today asking if there was another update. Thanks!

rothja commented 6 years ago

@MicahMcKittrick-MSFT I got a response today that this change is officially submitted and slated for work, but it is a large change for the Azure web team and that has been one of the reasons for the delay. The good news is that it has not been forgotten. I apologize it is taking so long.

JosieW commented 5 years ago

Is there any update on this? I've been looking at pricing for constrained vCPU VMs today and it still doesn't seem to reflect the saving on licence cost.

JosieW commented 5 years ago

Ok on further investigation it seems like it doesn't make any difference when you go from 4 to 2 or 1 vCPU e.g.:

E8 v3 = £2.93/hour E8-4 v3 = £1.81/hour E8-2 v3 = £1.81/hour as well

Where as for something like a DS12 v2 the 4,2, or 1 vCPU versions are all £1.48/hour.

Is there a minimum of 4 vCPUs for the PAYG licenses (and therefore the 2 or 1 cpu variants are only beneficial for BYOL)? Or is there still a bug in the calculator and the price we'd actually pay would be less?

rothja commented 5 years ago

@JosieW Thanks. I wonder if this has to do with the 4 core minimum per physical processor that SQL Server is licensed with in the non-Azure licensing world. I'll check with my contacts and get back to you on this.