How to manage resources in reserved instance?

Question

We want to have 20 vCPU in elastic pool in Azure in reserved instances. If we need to temporarly increase the pool, how will it impact reservation?

Answer 1

Hi @Monika Chojnowska,

Welcome to the Microsoft Q&A and thank you for posting your questions here.

If we need to temporarly increase the pool, how will it impact reservation?

If you temporarily increase the vCPU count in your Azure SQL Database elastic pool beyond the reserved instance capacity, it will impact your reservation in the following ways:

Billing Impact: You will be billed for the additional vCPUs at the pay-as-you-go rate for the duration of the increase. Your reserved instance discount will only apply to the originally reserved 20 vCPUs.

Reservation Coverage: The reservation will continue to cover the original 20 vCPUs. Any vCPUs beyond this will not be covered by the reservation and will incur additional charges.

Scaling Process: When you increase the size of your elastic pool, a new instance is created. This might cause a short service interruption as databases are copied to the new instance.

Extra vCPUs: The extra vCPUs will boost performance temporarily. Once you reduce the size back, the pool will return to its original capacity.

For more information, please refer the documents:
https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-scale?view=azuresql&tabs=azure-portal

https://learn.microsoft.com/en-us/azure/azure-sql/database/resource-limits-vcore-elastic-pools?view=azuresql

Hope this helps. Do let us know if you any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.