Save costs for resources with reserved capacity - Azure SQL Database & SQL Managed Instance
Save money with Azure SQL Database and SQL Managed Instance by committing to a reservation for compute resources compared to pay-as-you-go prices. With reserved capacity, you make a commitment for SQL Database and/or SQL Managed Instance use for a period of one or three years to get a significant discount on the compute costs. To purchase reserved capacity, you need to specify the Azure region, deployment type, performance tier, and term.
You do not need to assign the reservation to specific SQL Database, or SQL Managed Instance. Matching existing deployments that are already running or ones that are newly deployed automatically get the benefit. By purchasing a reservation, you commit to usage for the compute costs for a period of one or three years. As soon as you buy a reservation, the compute charges that match the reservation attributes are no longer charged at the pay-as-you go rates. A reservation does not cover software, networking, or storage charges associated with the service. At the end of the reservation term, the billing benefit expires and the SQL Database or SQL Managed Instance are billed at the pay-as-you go price. Reservations do not auto-renew. For pricing information, see the reserved capacity offering.
- You must be in the owner role for at least one Enterprise or individual subscription with pay-as-you-go rates.
- For Enterprise subscriptions, Add Reserved Instances must be enabled in the EA portal. Or, if that setting is disabled, you must be an EA Admin on the subscription. reserved capacity.
The details on how enterprise customers and Pay-As-You-Go customers are charged for reservation purchases, see understand Azure reservation usage for your Enterprise enrollment and understand Azure reservation usage for your Pay-As-You-Go subscription.
Determine correct size before purchase
The size of reservation should be based on the total amount of compute used by the existing or soon-to-be-deployed SQL Database or SQL Managed Instance within a specific region and using the same performance tier and hardware generation.
For example, let's suppose that you are running one general purpose, Gen5 – 16 vCore elastic pool, and two business critical, Gen5 – 4 vCore single databases. Further, let's supposed that you plan to deploy within the next month an additional general purpose, Gen5 – 16 vCore elastic pool, and one business critical, Gen5 – 32 vCore elastic pool. Also, let's suppose that you know that you will need these resources for at least 1 year. In this case, you should purchase a 32 (2x16) vCores, 1 year reservation for single database/elastic pool general purpose - Gen5 and a 40 (2x4 + 32) vCore 1 year reservation for single database/elastic pool business critical - Gen5.
Buy reserved capacity
- Sign in to the Azure portal.
- Select All services > Reservations.
- Select Add and then in the Purchase Reservations pane, select SQL Database to purchase a new reservation for SQL Database.
- Fill-in the required fields. Existing SQL Databases (single or pooled) or SQL Managed Instances that match the attributes you select qualify to get the reserved capacity discount. The actual number of your SQL Databases or SQL Managed Instances that get the discount depend on the scope and quantity selected.
The following table describes required fields.
|Subscription||The subscription used to pay for the capacity reservation. The payment method on the subscription is charged the upfront costs for the reservation. The subscription type must be an enterprise agreement (offer numbers: MS-AZR-0017P or MS-AZR-0148P) or an individual agreement with pay-as-you-go pricing (offer numbers: MS-AZR-0003P or MS-AZR-0023P). For an enterprise subscription, the charges are deducted from the enrollment's monetary commitment balance or charged as overage. For an individual subscription with pay-as-you-go pricing, the charges are billed to the credit card or invoice payment method on the subscription.|
|Scope||The vCore reservation's scope can cover one subscription or multiple subscriptions (shared scope). If you select:
Shared, the vCore reservation discount is applied to SQL Database or SQL Managed Instance running in any subscriptions within your billing context. For enterprise customers, the shared scope is the enrollment and includes all subscriptions within the enrollment. For Pay-As-You-Go customers, the shared scope is all Pay-As-You-Go subscriptions created by the account administrator.
Single subscription, the vCore reservation discount is applied to the SQL Databases or SQL Managed Instances in this subscription.
Single resource group, the reservation discount is applied to the SQL Databases or SQL Managed Instances in the selected subscription and the selected resource group within that subscription.
|Region||The Azure region that's covered by the capacity reservation.|
|Deployment Type||The SQL resource type that you want to buy the reservation for.|
|Performance Tier||The service tier for the SQL Databases or SQL Managed Instances.|
|Term||One year or three years.|
|Quantity||The amount of compute resources being purchased within the capacity reservation. The quantity is a number of vCores in the selected Azure region and Performance tier that are being reserved and will get the billing discount. For example, if you are running or planning to run multiple SQL Databases with the total compute capacity of Gen5 16 vCores in the East US region, then you would specify quantity as 16 to maximize the benefit for all the databases.|
- Review the cost of the capacity reservation in the Costs section.
- Select Purchase.
- Select View this Reservation to see the status of your purchase.
Cancel, exchange, or refund reservations
You can cancel, exchange, or refund reservations with certain limitations. For more information, see Self-service exchanges and refunds for Azure Reservations.
vCore size flexibility
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 SQL 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 un-applied buffer in your reservation, you can effectively manage the performance spikes without exceeding your budget.
You cannot reserve serverless or DTU-based (basic, standard, or premium) databases in SQL Database.
Need help? Contact us
If you have questions or need help, create a support request.
The vCore reservation discount is applied automatically to the number of SQL Databases or SQL Managed Instances that match capacity reservation scope and attributes. You can update the scope of the capacity reservation through Azure portal, PowerShell, CLI or through the API.
To learn how to manage the capacity reservation, see manage reserved capacity.
To learn more about Azure Reservations, see the following articles: