question

ChristianLoose-3836 avatar image
0 Votes"
ChristianLoose-3836 asked ChristianLoose-3836 answered

Question about SQL Reserved vCores minimum and scaling

I'd like to publish a website and started using azure, but now I have a question regarding SQL databases.

My plan is to purchase an Elastic Pool, Gen5, Business Critical, which seems to need a minimum of 4 vCores.
To decrease costs, I'm also planning to purchase SQL reserved vCores for this pool, but I still have two questions about this, which I couldn't find an answer for in the docs.

-Is is possible to buy a 4 vCore business critical reservation? I read that you need to reserve at least 8 cores, but that info wasn't specific to SQL, so I suppose that's only for VMs?
-What about scaling and resevations? What if we need to scale up to 6 or 8 cores, or even scale down to (f.ex.) Generic Tier with 8 vCores?

Thanks for your feedback, very appreciated! (As Azure sales are never reachable via chat - at least it's always disabled for me...)
Christian

azure-sql-database
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @ChristianLoose-3836 Welcome to Microsoft Q&A and Thank you for posting your question.
We are looking into this and will get back to you shortly.

1 Vote 1 ·
OuryBa-MSFT avatar image
0 Votes"
OuryBa-MSFT answered

Hello @ChristianLoose-3836 You can buy a 4 vCore Business Critical reservation, the minimum for Elastic Pools is 4 vCore not 8. There’s flexibility to scale up or down within the same tier but not across the tiers. For instance if the you buy 16 vCores on BC, you can scale down to 8 or scale up to 32 without losing the reserved capacity benefit but you cannot get the reserved capacity benefit if you move to 16 vCore GP instead.

This doc explain it pretty well. https://docs.microsoft.com/en-us/azure/azure-sql/database/reserved-capacity-overview

I hope that answer your question. If yes, Please accept answer because it will be beneficial for other community members facing the same. Thanks

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ChristianLoose-3836 avatar image
0 Votes"
ChristianLoose-3836 answered

Thanks a lot, that is exactly the information I was looking for! 👍

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.