Simplify Your Azure Bill by Resource Group


By:   |   Updated: 2019-10-03   |   Comments   |   Related: More > Azure

Problem

I have a number of Azure SQL Server resources to manage. My manager has asked me if it is possible to categorize the Azure resources based on the various departments within the company and also to consolidate the resource billing information by department within the organization. Is there any easy way this can be accomplished in Azure?

Solution

This tip assumes that you already have resources in your Azure environment. If you are new to Azure, you can subscribe to a trial account here which will give you access to Azure services for an year and a credit of USD $200. In this tip, we will learn about the concept of tags which is extremely useful to view detailed information and is handy when you have to deal with a huge number of resources in your subscription.

What are Azure tags?

Tags are basically applying metadata for your Azure resources which will help you to better organize your resources based on the metadata description. In Azure, tags are name\value pairs that you provide. For example, if you are creating an Azure SQL database, you can have a tag something like "Environment": "Pre-Prod". Azure resources can have multiple tags in order to classify the resources further.

Why create tags when we already have resource groups in Azure?

With resource groups in Azure, we can view the list of all the resources in that particular resource group quite easily. However, if we need to categorize the resources further based on a specific department within your organization, say for example, "Finance" or "HR", it would be quite hard to figure out what resources are for which department. The easier way of creating tags on Azure is by using policy management. This way you can automatically enforce a policy for creating tags on all your Azure resources at the time of deployment. By using Azure policies, you can ensure the tags to be of specific values and which meet your IT standards. However, in this tip, we will see a demo of creating tags and its benefits by using the Azure portal.

Creating tags using the Azure portal

In this screenshot, you can view the home page of the Azure portal.

azure home page

Click on the "sqltips" resource group to view details of the resource group. Once done, you will see this screen where you can click on the option to add "Tags". You can click on any one of the highlighted options.

create tags in azure

Once done, you will see this screen where you can enter details for the tag name\pairs.

edit tags in azure

You can provide suitable tag name\value pairs. Here are a few examples. Once done, click on the save option.

list tags in azure

Once done, you will see that the tags get associated to your resources as shown. Click on the ‘overview’ option to view the tag details.

show tags associted with azure resource

Similarly, do this for the other Azure resources.

View organized information on the Azure resources using Tags

Now, that you have assigned tags to a number of your resources, let's see the value that tagging adds to your resources. You can go to the option to search by tags on the Azure portal. On the main Azure portal, you can search for the option "Tags" on the search option as shown.

show azure resources by tag

Click on the option "Tags" to view details of the tags that are available. Here is a screenshot:

details of azure resource tags

Next, you can click on any of the tags to view more information of the resources that belong to that particular tag. As an example, below is a screenshot on clicking the tag- "Department: IT-Services".

azure resource tag details

This way, it is easy for you to view information of the resources that belong to a particular department. In the next section, we will see how we can use tags to collect billing information and organize the billing information based on the tags used.

View billing information based on Azure tags used

In this section, we will see how easy it is to consolidate billing information based on the assigned tags for the resources. In the Azure portal home page, click on the option – "Cost Management + Billing".

show azure billing info based on tags

Once done, click on the subscription ID as shown. You can already see the current cost for the subscription which is $0.33. When you click on the subscription ID, you will see this screen.

show azure billing info based on tags

Under the billing information, you can view details of the costs associated with the resource along with the forecast and remaining credit. The information appears to be quite generic with no details of the resources, etc. For more details on the billing information, you can click on the option – "Cost Analysis". Here, you can view more details like the resources used and resource locations.

show azure billing info based on tags

On the right-hand top corner, you have the "Group by" option. Click on the "Group by" option. You will see these options that are available.

show azure billing info based on tags

Under the group by menu, you will see several options that are available to view the billing information. One of them is the "Tag" option. When you click on the tag option, you will get the option to select the tags that are available.

show azure billing info based on tags

As you know, we have created a few tags in this demo and you can view them as the options to select. Click on the tag you are interested in, in this case, I clicked on the "department" tag.

show azure billing info based on tags

Here, you view the cost associated with the resources in the "department" tag. Also, there are several options to view the details of the billing information. In this case, I selected the "Column (stacked)" which provides the billing information in column details as shown. This way, you can get useful billing information based on the tags assigned to your resources and this would be extremely useful if you have to manage a huge number of Azure resources.

Next Steps
  • In this tip, you learned about tags that can be used for your Azure resources
  • Tags are basically name\value pairs which help you to categorize Azure resources
  • Tags can be created in a few easy steps
  • In this tip, you saw a demo on creating tags for a few SQL resources in Azure
  • In the demo, you saw how easily billing information can be consolidated based on the assigned tags
  • Try out this demo on your own Azure environment
  • Refer to these other useful articles available on MSSQLTips related to Azure


Last Updated: 2019-10-03


get scripts

next tip button



About the author
MSSQLTips author Mohammed Moinudheen Mohammed Moinudheen is a SQL Server DBA with over 6 years experience managing production databases for a few Fortune 500 companies.

View all my tips
Related Resources




Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name
*Email
Email me updates

Signup for our newsletter

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.






download

























get free sql tips

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



Learn more about SQL Server tools