Scaling of Azure SQL reserve instance

Zara John 66 Reputation points
2021-09-22T05:39:42.673+00:00

I have Azure SQL reserve instance for 3 years. Can I increase the capacity i.e. scale out or not when it is reserved for 3 years?

Azure SQL Database
0 comments No comments
{count} votes

Accepted answer
  1. Anurag Sharma 17,606 Reputation points
    2021-09-22T06:19:09.71+00:00

    Hi @ZaraJohn-9891, welcome to Microsoft Q&A forum.

    Yes we can scale up and scale down the performance tier. As per the below article ,"vCore size flexibility helps you scale up or down within a performance tier and region, without losing the reserved capacity benefit. Reserved capacity also provides you with the flexibility to temporarily move your hot databases in and out of elastic pools (within the same region and performance tier) as part of your normal operations without losing the reserved capacity benefit. By keeping an unapplied buffer in your reservation, you can effectively manage the performance spikes without exceeding your budget."

    However there is a limitation as mentioned in the same document "You cannot reserve DTU-based (basic, standard, or premium) databases in SQL Database."

    Referenced Article: Save costs for resources with reserved capacity - Azure SQL Database & SQL Managed Instance

    Please let us know if this helps or else we can discuss further on the same.

    ----------

    Please don't forgot to click on accept it as answer button 134241-image.png wherever the information provided helps you. This can be beneficial to other community members as well..

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.