Understanding Your Azure Bill

June 24, 2015   //   Cloud, ,

Recently ranked by Gartner as an industry leader due to its ability to help organizations do more, work faster and save money, Microsoft Azure is a great, reasonably priced cloud offering. However, the a la carte service pricing model can add up quickly if you don’t properly manage your Azure implementation. In addition to planning your cloud environment to take advantage of Azure’s sizing and scaling capabilities, it’s also important that you review and monitor your monthly Azure usage and invoice in order to understand where you’re spending your money.

The Azure Billing Portal

It’s important to review your Azure bill on regular basis so that you have an idea of what usage charges to expect. You are probably already reviewing the PDF version of your Azure invoice and have found that the invoice is an aggregated summary. The lack of details regarding the instance breakdown and the normalization of Cloud Services and Virtual Machine Sizing can make this process confusing. Fortunately, the Azure Billing Portal also provides an option to download the details of your statement as a CSV file. The CSV extract shows the actual usage by instance. Unfortunately, the daily usage section does not contain billing rate information, which can make detail analysis time consuming.

Creating a PivotTable Report

Your review should be a two-step process. The first step is to view the summary detail in Excel and create a PivotTable report on the name versus the sum of the value (see Microsoft’s Pivot Tutorial). Typically, you’ll find that Azure App Services, Virtual Machines, and Data Services consume most of your budget. Regardless of the actual split, the initial analysis will provide you with a good idea of what parts of your bill you should be concerned about.


Looking At What Matters Most

The next step is to drill into the details to see if they match your expectations. This can be done by creating a pivot on the “Details” section of the extract. In order to create the pivot and have the data aggregate correctly, you will need to remove the date from the component description. A good starting pivot would be to view “Name and Component” by sum of the consumed units.

One “gotcha” when reviewing the usage of Cloud Services and Virtual Machines instances is that the consumed units are calculated as Single Processor Instances. When reviewing the details, some items to inspect are:

  • Review the services and instances that are incurring charges
    • Validate that all the services that you are charged for are actually in use
    • Keep in mind that many items that are billed by the hour are billed regardless of activity, even if they are turned off
  • Review the units that you are being billed for
    • For items billed by the hour, compare the billed units to the number of hours in the month to determine the average processor instances used in the month. This number can be helpful when reviewing the sizing and scaling of services in your Azure environment.

Actively Manage the Cloud to Save Money

Monitoring your Azure spend is an important part of making sure your company’s decision to move to the cloud was the right decision. Cloud solutions are only more cost effective then on-premises solutions if they are actively managed. At SWC, we have the expertise to effectively assist you in planning, implementing, and monitoring your cloud solution. Contact us today and tell us about your cloud or on-premises challenges. 

Recommended Posts

If you enjoyed this post from Robert, please check out a few of our past related posts.

Performance and Schedule Autoscaling in Microsoft Azure
Five Questions to Ask Before Investing in a Cloud Service
Preparing for Server 2003 End of Life by Migrating to Microsoft Azure
Extending Your Domain into Microsoft Azure: It’s Not as Scary as You Think
How to Get More Out of the Cloud for Less
Built-in Mobile Device Management Is Now Freely Available for Office 365 Commercial Plans
Creating an Azure Environment On-Premises with Windows Azure Pack
Deployments and Rollbacks in Azure
Microsoft RemoteApp: Your Apps in the Cloud
Flexible and Scalable Web Hosting with Microsoft Azure
Microsoft’s Annual Technology Roadmap Event Recap