Save Money On Your Azure Monthly SQL Database Bill

, 2018-09-05 (first published: )

Microsoft gives you two purchasing models for your Azure SQL Databases (SQL DB), a DTU and a vCore based model (logical CPU’s). Both options allow you to scale up or down based on your compute and storage requirements. Regardless of which model you choose performance tuning can save you money using SQL DB.

DTU (s) (Database Transaction Units) measure  “a blended measure of CPU, memory, and data I/O and transaction log I/O” that Microsoft uses to help estimate which DTU based Service Tier you should be using. By reducing your I/O, memory or CPU consumption you utilize less DTUs or cores and thus can step down service tiers. Stepping down service tiers helps to save money.

It’s about reducing the amount of resources you consume. Just like On-Prem databases, Azure databases need performance tuning. However, unlike most On-Prem environments Azure makes it easy to scale down SQL DB processing resources without any down time. On top of that it allows you to save thousands of dollars a month while doing it.

For instance, let’s take a common scenario we have all seen. Most environments have some type of ETL process that loads data into a database used for reporting. In most of these cases, this can be a resource intensive process requiring a very high DTU service tier to accomplish this potentially periodic data load. What if you could scale your environment to a higher DTU service tier  to meet this load demand and then scale it down when not needed? Imagine how much money you could save the company. In a recent talk with a friend of mine, he was able to implement such a process in such a way his company’s monthly Azure SQLDB bill went from $55k a month to $21k. That’s an astronomical savings (note this a very large environment).  Here is a resource for scaling using a scheduled auto scale.

If scaling down based on work load doesn’t fit your environment and you are still looking for ways to save money start index tuning. An easy place to start is looking at your heaviest I/O consumption queries, you can use the Azure SQL Database Query Performance Insights to help you identify these. Reducing the number of reads is the goal. The less reads you have the less I/O and memory consumption you use and the smaller the DTU service tier you need.  If index tuning is not something you do well, Azure SQL Database includes Automated Tuning option that you can enable and it will create indexes (and potentially remove newly created, underutilized indexes) for you. Creating and managing your indexes is one of the simplest ways to reduce Azure related costs and Microsoft has built-in the tools to help. You’ll be surprised how quickly you can make an impact on your bottom line with Index tuning.

This are only two ways you can save money on your monthly Azure bill.

For even more ways to save, check out this month’s Denny Cherry and Associate’s newsletter coming out soon.

Sign up to stay informed at https://dcac.co/contact/stay-informed .

Rate

Share

Share

Rate

Related content

Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?

Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.

2009-02-23

1,567 reads

Networking - Part 4

You may want to read Part 1 , Part 2 , and Part 3 before continuing. This time around I'd like to talk about social networking. We'll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let...

2009-02-17

1,530 reads

Speaking at Community Events - More Thoughts

Last week I posted Speaking at Community Events - Time to Raise the Bar?, a first cut at talking about to what degree we should require experience for speakers at events like SQLSaturday as well as when it might be appropriate to add additional focus/limitations on the presentations that are accepted. I've got a few more thoughts on the topic this week, and I look forward to your comments.

2009-02-13

360 reads