SQL Database Reserved vCores

Sipo Ching 0

We have a number of databases running on Azure SQL Server resources. We would like to change them to SQL Database Reserved vCores. Is there a way to change the from Azure SQL Database to SQL Database Reserved vCores. We would like to find the easiest way to move our database (production) to the SQL Database Reserved vCores without downtime.

Vijayalaxmi Kattimani 1,480 Reputation points Microsoft Vendor

2025-02-21T15:35:08.5666667+00:00

Hi @Sipo Ching,

Following up to see, we haven’t heard from you on the last response provided by TP.

In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

1 answer

TP 104.4K Reputation points

2025-02-21T05:28:03.4333333+00:00

Hi,

There is no downtime. After you purchase reservation for the number of vCores you need, the discount for compute will be applied automatically.

NOTE: The above assumes you are currently running Azure SQL Database vCore Provisioned.

To purchase reservation you may navigate to Reservations in the Azure portal:

https://portal.azure.com/#view/Microsoft_Azure_Reservations/ReservationsBrowseBlade/productType/Reservations

When making your purchase you want to make sure you select the correct Performance Tier, Region, Term (1 or 3 years), Billing Frequency, and quantity. Performance Tier, Region, Quantity need to cover the Azure SQL resources you are currently running.

Please see article below for more information:

Save on compute costs with Azure Reservations - Azure SQL Database & SQL Managed Instance

https://learn.microsoft.com/en-us/azure/azure-sql/database/reservations-discount-overview?view=azuresql

Additionally, I recommend you review Azure SQL Database Reserved Capacity FAQs at the bottom of pricing page:

https://azure.microsoft.com/en-us/pricing/details/azure-sql-database/single/

Please click Accept Answer and upvote if the above was helpful.

Thanks.

-TP
Please sign in to rate this answer.
Sipo Ching 0 Reputation points

2025-02-21T13:42:36.81+00:00

I want to clarify that I have the database currently running as "Pay-as-you-go". How do I change them to the Azure SQL Database Vcore Reserved model?

TP 104.4K Reputation points

2025-02-21T15:03:10.2366667+00:00

I want to clarify that I have the database currently running as "Pay-as-you-go". How do I change them to the Azure SQL Database Vcore Reserved model?

Please navigate to each one of your Azure SQL Databases in the portal, then click on Settings - Compute + storage blade. What do you have for Service tier and Compute tier?

Knowing your Service tier and Compute tier will help me answer your question.

If you like you could post screenshot. Below is sample screenshot showing Service tier: General Purpose and Compute tier: Provisioned

Vijayalaxmi Kattimani 1,480 Reputation points Microsoft Vendor

2025-02-21T17:56:54.7033333+00:00

Hi Sipo Ching,

Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.

In addition to the response provided by TP, I would like to add the following information.

We would like to inform you that, Azure SQL Database and Azure SQL Managed Instance enable you to dynamically add more resources to your database with minimal downtime; however, there is a switch over period where connectivity is lost to the database for a short amount of time, which can be mitigated using retry logic.

To migrate an Azure SQL Database to a SQL Database Reserved vCores model without downtime, you can purchase the reserved vCores through the Azure portal. Once the reservation is made, the discount will be applied automatically, allowing for a seamless transition without affecting database availability.

To change your Azure SQL Database from the Pay-as-you-go model to the vCore Reserved model, you can do this through the Azure portal.

Step1: Navigate to your SQL Database and you wish to change from the Pay-as-you-go model.

Step2: Click on the "Pricing tier" link on the Overview page of your database. This will allow you to modify the current pricing model.

Step3: In the pricing tier options, select the vCore Reserved capacity that fits your workload requirements. You can choose between different service tiers such as General Purpose, Business Critical, or Hyperscale, depending on your needs.

Step4: After selecting the desired vCore Reserved model, review the changes and confirm to apply them. This will switch your database to the reserved pricing model.

Please monitor the performance and billing to ensure a successful transition and to maximize the benefits of the reserved pricing.

Please refer to the below mentioned link for more information.

https://learn.microsoft.com/en-us/azure/azure-sql/database/scale-resources?view=azuresql

https://learn.microsoft.com/en-us/azure/azure-sql/database/service-tiers-sql-database-vcore?view=azuresql

https://techcommunity.microsoft.com/blog/azuresqlblog/migrating-to-azure-sql-database-with-zero-downtime-for-read-only-workloads/386180

I hope this information helps. Please do let us know if you have any further queries.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

SQL Database Reserved vCores

1 answer

Your answer