Thursday, August 23, 2018

SQL Database Reserved Capacity is now generally available

The general availability of Azure SQL Database reserved capacity has released by Microsoft Azure team. It’s now available on single and elastic pool databases. This will be the most cost-effective cloud for your workloads. And the pricing tier saves up to 33% compared to license-included pricing by pre-paying for your SQL database vCores for a one or three-year term.

What makes Azure as the most cost-effective cloud for SQL Server workloads

Now a days users can save up to 55 percent using Azure Hybrid Benefit for SQL Server with the new vCore-based purchasing model in SQL Database. By using reserved capacity on single databases and elastic pools users can save even more up to 80%. And the best part is you combine your Azure Hybrid Benefit with reserved capacity as well.

Single subscription or Shared subscription?

SQL Database reserved capacity pricing is scoped to either a single subscription or shared. It allows you to control how many subscriptions can use the benefit and how the reservation is applied to specific subscriptions.
·         Single subscription 
Your reserved capacity discount will apply to your SQL Database resources within the selected subscription.
·         Shared subscription
The billing benefit can be shared across any subscription in the enrollment (i.e., Enterprise Agreement customers) or account (i.e., Pay-as-you-go customers), except for MSDN subscriptions in the enrollment or non-Pay-as-you-go subscriptions in the account.

Make Changes. Keep your savings
There is a magical thing called vCore size flexibility in SQL Database reserved capacity. Using that users can scale up or down their performance tier. You can do it within your region as well as with in performance tier. This will not impact user’s reserved capacity pricing.
According to Microsoft:
If you purchase 16 Gen5 vCores of reserved capacity for SQL Database general purpose and decide to deploy a 4 vCore database and an 8 vCore elastic pool, both with Gen 5 compute, your reserved capacity benefit will automatically apply to both. If you decide to scale up your database to 8 vCores, the reserved capacity benefit will also automatically apply.
Users can temporarily move their host databases between pools and single databases. Within the same region and performance tier these can be done as a part of user’s normal operation, without losing the reserved capacity benefit. When users have an un-applied buffer in your reservation they can effectively manage the performance spikes without exceeding your budget.
SQL Database reserved capacity is initially available to single databases and elastic pools, with managed instance support coming in the future, and can be purchased through the Azure portal. For more information on reserved capacity pricing, please visit the SQL Database pricing page and review Microsoft documentation.

No comments:

Post a Comment