ERWIN & BUSINESS ANALYTICS

Azure SQL Data Warehouse: How to setup Reserved Capacity

by May 5, 2019

Purchase your Azure SQL Datawarehouse Reservation

 

Since a few weeks you can buy Reserved Capacity for an Azure SQL Datawarehouse (SQLDW). This Reservation can save you up to 65% on the normal Pay as You go rates with a 3 year pre-commit. A pre-commit of 1 year will be discounted up to 35%.

These savings will only effect the compute power. You will charged separately for the storage with the normal Pay as You go rates.

To purchase a reservation,  you need to sign-in to the Azure Portal first and then search for reservations.

Reserved Capacity Azure SQLDW

After you have clicked on Purchase Now, you will need to choose the Azure SQLDW option.

Reserved Capacity Azure SQLDW

Select the Region, be aware that if you want to run Several SQLDW’s (Dev/Test/Prod) and you want to make use of the benefits of the reserved capacity that these SQLDW’s must all be created in the Region in which the reservation is made.

When you’re running a Enterprise Subscription and you have more then 1 Subscription you can change the Scope to  “Shared”. With this option selected you can use the Reserved Capacity across all subscription within the same EA Enrollment.

Reserved Capacity Azure SQLDW

Select 1 or 3 year Term.

Reserved Capacity Azure SQLDW

Choose a quantity. The reserved capacity is calculated by 100 cDWU(Data Warehouse units). Choose the quantity you want to reserved. In case you select 5 cDWU, you will have 500 cDWU of reserved capacity every hour.

Reserved Capacity Azure SQLDW

 

Reserved Capacity Azure SQLDW

The last step is to Purchase your Reservation.

Reserved Capacity nice to know’s

Storage and Network are charged separately, for these Azure Services the Reserved Capacity Discount will not be applied.

The Reserved Capacity Discount is applied on running Azure SQLDW Instances on a hourly basis.

If you don’t have a Azure SQLDW Instance deployed for an hour, then the reserved capacity is wasted for that hour. It doesn’t carry over. Unless you have more then 1 Azure SQLDW Instance running, the reservation is automatically applied to other matching instances in that hour.

Some Examples:

1 – Running 1 Azure SQLDW Instance:

You have purchased 5 units of 100 cDWU.

On the moment you scale to 1000 cDWU, you will be charged with a Pay as You go rates for 700 cDWU.

2 – Running 2 Azure SQLDW Instances:

You have purchased 15 units of 100 cDWU.

1 Azure SQLDW Instance is running 500 cDWU and the other one 1000 cDWU.

No extra cost will be applied.

3 – Running 2 Azure SQLDW Instances:

You have purchased 15 units of 100 cDWU.

1 Azure SQLDW Instance is running 500 cDWU from 9 am to 5 pm  and the other one 1500 cDWU the whole day.

You will be charged for a Pay as You go rates for 500 cDWU from 9 am to 5 pm.

Reserved Capacity Azure SQLDW

Thank you for reading this article and hopefully it will make things clear to you.

Within a few days I will publish a new article in which I describe how much you could possibly save if you still want to scale up or down during certain periods of the day. If there are any questions left about this article, don’t hesitate to ask them to me.

UPDATE 6th May

Reserved Capacity versus Pas as You go

Azure SQL Data Warehouse: How to setup Reserved Capacity

Feel free to leave a comment

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

11 + three =

This site uses Akismet to reduce spam. Learn how your comment data is processed.

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

eighteen − eleven =

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Scale SQL Database dynamically with Metadata

Scale SQL Database Dynamically with Metadata Use this template to scale up and down an Azure SQL Database in Azure Synapse Analytics or in Azure Data Factory. This article describes a solution template how you can Scale up or down a SQL Database within Azure Synapse...

Azure Purview Costs in Public Preview explained

Why are you potentially charged for Azure Purview during the public preview? Since I published my post that Azure Purview started billing as of January 21th, I got a lot of questions how billing was working. UPDATE 27th of February: We are extending the Azure Purview...

Exploring Azure Synapse Analytics Studio

Azure Synapse Workspace Settings In my previous article, I walked you through "how to create your Azure Synapse Analytics Workspace". It's now time to explore the brand new Synapse Studio. Most configuration and settings can be done through the Synapse Studio. In your...

Azure DevOps and Azure Feature Pack for Integration Services

Azure Feature Pack for Integration ServicesAzure Blob Storage A great addition for SSIS is using extra connectors like  Azure Blob Storage or Azure Data Lake Store which are added by the Azure Feature Pack. This Pack needs to be installed on your local machine. Are...

Create an Azure Synapse Analytics Apache Spark Pool

Adding a new Apache Spark Pool There are 2 options to create an Apache Spark Pool.Go to your Azure Synapse Analytics Workspace in de Azure Portal and add a new Apache Spark Pool. Or go to the Management Tab in your Azure Synapse Analytics Workspace and add a new...

Service Healths in Azure

Creating Service Health Alerts in AzureAzure Portal In the Azure Portal go to Monitor – Service Health – Health alerts If you have created alerts before you will see them over here. Assuming you haven’t created an Alert before, we will start to create an Alert.1...

Azure SQL Data Warehouse: Reserved Capacity versus Pay as You go

How do I use my Reserved Capacity correctly? Update 11-11-2020: This also applies to Azure Synapse SQL Pools. In my previous article you were introduced, how to create a Reserved Capacity for an Azure SQL Datawarehouse (SQLDW). Now it's time to take a look at how this...

Create Virtual Machines with Azure DevTest Lab

A while ago I had to give a training. Normally I would roll out a number of virtual machines in Azure. Until someone brought my attention to an Azure Service, Azure DevTest Labs. With this Azure service you can easily create a basic image and use this image to roll...

Using Azure Automation to generate data in your WideWorldImporters database

CASE: For my test environment I want to load every day new increments into the WideWorldImporters Azure SQL Database with Azure Automation. The following Stored Procedure is available to achieve this. EXECUTE DataLoadSimulation.PopulateDataToCurrentDate...

SSMS 18.1: Schedule your SSIS Packages in Azure Data Factory

Schedule your SSIS Packages with SSMS in Azure Data Factory(ADF) This week SQL Server Management Studio version 18.1 was released, which can be downloaded from here. In version 18.1 the Database diagrams are back and from now on we can also schedule SSIS Packages in...