},

{

"source_path": "articles/virtual-machines/linux/prepay-rhel-software-charges.md",

"redirect_url": "/azure/virtual-machines/linux/prepay-suse-software-charges",

"redirect_document_id": true

},

}

- name: SQL Data Warehouse

href: billing-prepay-sql-data-warehouse-charges-with-reserved-capacity.md

- name: Azure software plans

- name: SQL Data Warehouse

href: billing-how-reservation-discount-is-applied-to-azure-sql-dw.md

- name: Azure software plans

ms.date: 04/13/2019

You must have owner access on the Reservation Order to exchange or refund an existing reservation.

title: How reservation discounts apply to Azure SQL Data Warehouse | Microsoft Docs

description: Learn how reservation discounts apply to Azure SQL Data Warehouse to help save you money.

services: billing

author: yashesvi

manager: yashar

ms.service: billing

ms.topic: conceptual

ms.date: 04/13/2019

ms.author: banders

After you buy Azure SQL Data Warehouse reserved capacity, the reservation discount is automatically applied to data warehouses that exist in that region. The reservation discount applies to the usage emitted by the SQL Data Warehouse cDWU meter. Storage and networking are charged at pay-as-you-go rates.

The SQL Data Warehouse reserved capacity discount is applied to running warehouses on an hourly basis. If you don't have a warehouse deployed for an hour, then the reserved capacity is wasted for that hour. It doesn't carry over.

After purchase, the reservation that you buy is matched to SQL Data Warehouse usage emitted by running warehouses at any point in time. If you shut down some warehouses, then reservation discounts automatically apply to any other matching warehouses.

For warehouses that don't run for a full hour, the reservation is automatically applied to other matching instances in that hour.

The following examples show how the SQL Data Warehouse reserved capacity discount applies, depending on the deployments.

- **Example 1**: You purchase 5 units of 100 cDWU reserved capacity. You run a DW1500c SQL Data Warehouse instance for an hour. In this case, usage is emitted for 15 units of 100 cDWU usage. The reservation discount applies to the 5 units that you used. You are charged using pay-as-you-go rates for the remaining 10 units of 100 cDWU usage that you used.

- **Example 2**: You purchase 5 units of 100 cDWU reserved capacity. You run two DW100c SQL Data Warehouse instances for an hour. In this case, two usage events are emitted for 1 unit of 100 cDWU usage. Both usage events get reserved capacity discounts. The remaining 3 units of 100 cDWU reserved capacity are wasted and don't carry over for future use.

- **Example 3**: You purchase 1 unit of 100 cDWU reserved capacity. You run two DW100c SQL Data Warehouse instances. Each runs for 30 minutes. In this case, both usage events get reserved capacity discounts. No usage is charged using pay-as-you-go rates.

- If you have questions or need help, [create a support request](https://go.microsoft.com/fwlink/?linkid=2083458).

To learn more about Azure Reservations, see the following articles:

- [What are Azure Reservations?](billing-save-compute-costs-reservations.md)

- [View reservation transactions](billing-view-reservations.md)

- [Get reservation transactions and utilization through API](billing-reservation-apis.md)

- [Manage reservations](billing-manage-reserved-vm-instance.md)

ms.service: billing

ms.date: 04/13/2019

When you purchase of a reservation, two objects are created: **Reservation Order** and **Reservation**.

At the time of purchase, a Reservation Order has one Reservation under it. Actions such as split, merge, partial refund, or exchange create new reservations under the **Reservation Order**.

To view a Reservation Order, go to **Reservations** > select the reservation, and then click the **Reservation order ID**.


A reservation inherits permissions from its reservation order.

You can delegate reservation management by adding people to roles on the reservation order or the reservation. By default, the person that places the reservation order and the account administrator have the Owner role on the reservation order and the reservation.

You can manage access to reservations orders and reservations independently from the subscriptions that get the reservation discount. When you give someone permissions to manage a reservation order or the reservation, it doesn't give them permission to manage the subscription. Similarly, if you give someone permissions to manage a subscription in the reservation's scope, it doesn't give them rights to manage the reservation order or the reservation.

To perform an exchange or refund, the user must have access to the reservation order. When granting someone permissions, it’s best to grant permissions to the reservation order, not the reservation.

title: Prepay for SQL Data Warehouse charges with Azure reserved capacity | Microsoft Docs

description: Learn how you can prepay for SQL Data Warehouse charges with reserved capacity to save money.

services: billing

author: yashesvi

manager: yashar

ms.service: billing

ms.topic: conceptual

ms.date: 04/13/2019

ms.author: banders

You can save money with Azure SQL Data Warehouse by prepaying 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](https://azure.microsoft.com/pricing/details/sql-data-warehouse/gen2/).

You can buy Azure SQL Data Warehouse reserved capacity in the [Azure portal](https://portal.azure.com/#blade/Microsoft_Azure_Reservations/ReservationsBrowseBlade). To buy reserved capacity:

- 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](https://ea.azure.com/). 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](billing-understand-reserved-instance-usage-ea.md) and [understand Azure reservation usage for your Pay-As-You-Go subscription](billing-understand-reserved-instance-usage.md).

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.

1. Sign-in to the [Azure portal](https://portal.azure.com/).

2. Select **All services** > **Reservations**.

3. 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 upfront 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.

4. Select a scope. Use the Scope list to choose a subscription scope.

- With the **Single** option, the reservation discount is applied to SQL Data Warehouse deployed in the selected subscription.

- With the **Shared** option, the reservation discount is applied to instances running in any subscriptions within your billing context.

- 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.

5. Select a region to choose an Azure region that's covered by the reserved capacity.

6. 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.

7. Review the SQL Data Warehouse reserved capacity reservation cost in the **Costs** section.

8. Select **Purchase**.

9. Select **View this Reservation** to see your purchase status.

If you need to cancel your SQL Data Warehouse reserved capacity, there might be a 12% early termination fee. Refunds are based on the lowest price of either your purchase price or the current price of the reservation. Refunds are limited to $50,000.00 per year. The refund you receive is the remaining prorated balance minus the 12% early termination fee. To request a cancellation, go to the reservation in the Azure portal and select **Refund** to create a support request.

If you need to change your SQL Data Warehouse reserved capacity to another region or term, you can exchange it for another reservation that's of equal or greater value. The term start date for the new reservation doesn't carry over from the exchanged reservation. The one or three-year term starts when you create the new reservation. To request an exchange, open the reservation in the Azure portal, and select **Exchange** to create a support request.

For more information about how to exchange or refund reservations, see [Reservation exchanges and refunds](billing-azure-reservations-self-service-exchange-and-refund.md).

The 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](https://portal.azure.com/), PowerShell, CLI or through the API.

If you have questions or need help, [create a support request](https://portal.azure.com/).

- To learn more about how reservation discounts apply to Azure SQL Data Warehouse, see [How reservation discounts apply to Azure SQL Data Warehouse](billing-prepay-sql-data-warehouse-charges-with-reserved-capacity.md).

- To learn more about Azure Reservations, see the following articles:

- [What are Azure Reservations?](billing-save-compute-costs-reservations.md)

- [Manage Azure Reservations](billing-manage-reserved-vm-instance.md)

- [Understand Azure Reservations discount](billing-understand-reservation-charges.md)

- [Understand reservation usage for your Pay-As-You-Go subscription](billing-understand-reserved-instance-usage.md)

- [Understand reservation usage for your Enterprise enrollment](billing-understand-reserved-instance-usage-ea.md)