Save costs for SQL Data Warehouse charges with reserved capacity
You can save money with Azure SQL Data Warehouse by committing to a reservation for your cDWU usage for a duration of one or three years. To purchase SQL Data Warehouse reserved capacity, you need to choose the Azure region, and term. Then, add the SQL Data Warehouse SKU to your cart and choose the quantity of cDWU units that you want to purchase.
When you purchase a reservation, the SQL Data Warehouse usage that matches the reservation attributes is no longer charged at the pay-as-you go rates.
A reservation doesn't cover storage or networking charges associated with the SQL Data Warehouse usage.
When the reserved capacity expires, SQL Data Warehouse instances continue to run but are billed at the pay-as-you go rate. Reservations don't renew automatically.
For pricing information, see the SQL Data Warehouse reserved capacity offering.
- You must have the owner role for at least one enterprise or Pay-As-You-Go subscription.
- For Enterprise subscriptions, the Add Reserved Instances option must be enabled in the EA portal. If the setting is disabled, you must be an EA Admin.
- For the Cloud Solution Provider (CSP) program, only the admin agents or sales agents can purchase SQL Data Warehouse reserved capacity.
For more information about 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.
Choose the right size before purchase
The SQL Data Warehouse reservation size should be based on the total compute data warehouse units (cDWU) that you consume. Purchases are made in 100 cDWU increments.
For example, assume your total consumption of SQL Data Warehouse is DW3000c. You want to purchase reserved capacity for all of it. So, you should purchase 30 units of cDWU reserved capacity.
Buy SQL Data Warehouse reserved capacity
- Sign in to the Azure portal.
- Select All services > Reservations.
- Select a subscription. Use the Subscription list to choose the subscription that's used to pay for the reserved capacity. The payment method of the subscription is charged the costs for the reserved capacity. The subscription type must be an enterprise agreement (offer numbers: MS-AZR-0017P or MS-AZR-0148P) or Pay-As-You-Go (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 Pay-As-You-Go subscription, the charges are billed to the credit card or invoice payment method on the subscription.
- Select a scope. Use the Scope list to choose a subscription scope.
- Single resource group scope — Applies the reservation discount to the matching resources in the selected resource group only.
- Single subscription scope — Applies the reservation discount to the matching resources in the selected subscription.
- Shared scope — Applies the reservation discount to matching resources in eligible subscriptions that are in the billing context. For Enterprise Agreement customers, the billing context is the enrollment. For individual subscriptions with pay-as-you-go rates, the billing scope is all eligible subscriptions created by the account administrator.
- For enterprise customers, the billing context is the EA enrollment.
- For Pay-As-You-Go customers, the shared scope is all Pay-As-You-Go subscriptions created by the account administrator.
- Select a region to choose an Azure region that's covered by the reserved capacity.
- Choose a quantity. Enter the quantity of 100 Data Warehouse units (cDWU) that you want to purchase.
For example, a quantity of 30 would give you 3,000 cDWU of reserved capacity every hour.
- Review the SQL Data Warehouse reserved capacity reservation cost in the Costs section.
- Select Purchase.
- Select View this Reservation to see your purchase status.
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.
A reservation discount is applied automatically to the number of SQL Data Warehouse instances that match the SQL Data Warehouse reserved capacity scope and region. You can update the scope of the SQL Data Warehouse reserved capacity with the Azure portal, PowerShell, CLI or through the API.
Need help? Contact us
If you have questions or need help, create a support request.
To learn more about how reservation discounts apply to Azure SQL Data Warehouse, see How reservation discounts apply to Azure SQL Data Warehouse.
To learn more about Azure Reservations, see the following articles: