Home
%3CLINGO-SUB%20id%3D%22lingo-sub-718890%22%20slang%3D%22en-US%22%3EStep-by-Step%3A%20Finding%20and%20Analyzing%20Microsoft%20Azure%20Cloud%20Usage%20Costs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-718890%22%20slang%3D%22en-US%22%3E%3CP%3EHave%20you%20just%20seen%20last%20months%E2%80%99%20bill%2C%20or%20received%20an%20alert%20because%20you%20had%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fcost-management%2Ftutorial-acm-create-budgets%3FWT.mc_id%3Ditopstalk-blog-socuff%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20Budgets%20configured%3C%2FA%3E%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20your%20Cloud%20spend%20is%20different%20than%20what%20you%20were%20expecting%20it%20to%20be%2C%20you%E2%80%99ll%20want%20to%20do%20some%20detective%20work%20to%20isolate%20the%20reasons%20why.%20While%20your%20Azure%20invoice%20will%20detail%20your%20consumption%20of%20Microsoft%E2%80%99s%20Azure%20services%2C%20it%20won%E2%80%99t%20give%20you%20the%20context%20of%20your%20virtual%20resource%20configurations.%20It%E2%80%99s%20kind%20of%20like%20asking%20the%20electricity%20company%20to%20identify%20which%20home%20appliance%20used%20the%20most%20power%2C%20when%20you%20don%E2%80%99t%20have%20any%20smart%20home%20metering.%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3EAzure%20Cost%20Management%E2%80%99s%20Cost%20Analysis%20tool%20can%20help%20you%20break%20down%20the%20details.%20The%20trick%20is%20to%20change%20the%20granularity%2C%20grouping%20and%20filtering%20options%20inside%20the%20tool.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EPrerequisites%3A%3C%2FSTRONG%3E%3CBR%20%2F%3EYou'll%20need%20at%20least%20read%20access%20to%20your%20Azure%20account%20and%20Enterprise%20Agreement%20customers%20will%20need%20read%20access%20to%20one%20or%20more%20of%20the%20following%20scopes%3A%20Billing%20account%2C%20Department%2C%20Enrollment%20account%2C%20Management%20group%2C%20Subscription%2C%20Resource%20Group.%20Learn%20more%20about%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fcost-management%2Fassign-access-acm-data%3FWT.mc_id%3Ditopstalk-blog-socuff%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Eassigning%20access%20to%20Cost%20Management%20data%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3ESteps%3A%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E1.%20Inside%20the%20Azure%20Portal%2C%20select%20Cost%20Management%20%2B%20Billing.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E2.%20Under%20Cost%20Management%2C%20select%20Cost%20analysis.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E3.%20I%E2%80%99ve%20set%20the%20Scope%20to%20show%20all%20the%20costs%20for%20one%20particular%20subscription.%20The%20scope%20options%20you%20can%20choose%20from%20will%20depend%20on%20what%20kind%20of%20Microsoft%20agreement%20(subscription%20type)%20you%20have.%26nbsp%3BSet%20Granularity%20to%20Monthly%20and%20Group%20by%20Resource%20type%2C%20to%20see%20which%20kinds%20of%20resources%20are%20contributing%20the%20most%20to%20your%20monthly%20cost.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F120539i656EFA74999CAB80%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Cost-ResourceType.jpg%22%20title%3D%22Cost-ResourceType.jpg%22%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3EYou%20can%20hover%20over%20the%20colored%20bars%20to%20bring%20up%20a%20list%20of%20the%20associated%20costs%20per%20resource%20type%2C%20at%20a%20glance.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E5.%20Lets%20check%20out%20the%20Storage%20Accounts.%20Change%20Group%20by%20to%20Resource%20and%20add%20a%20filter%20for%20Resource%20Type%2C%20selecting%20microsoft%2Fstorage.storage%20accounts.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F120537i247BF21A344FCD3D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22cost-dbstorageresource.jpg%22%20title%3D%22cost-dbstorageresource.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENow%20we%20can%20see%20the%20%E2%80%9Cdbstorageu35mmfje6jiw2%E2%80%9D%20resource%20has%20contributed%20the%20most%20cost%20during%20the%20month%20of%20April%202019.%3CBR%20%2F%3E%3CBR%20%2F%3E6.%20Then%2C%20set%20the%20Group%20by%20to%20Meter%2C%20and%20add%20a%20filter%20for%20the%20Resource%20named%20dbstorageu35mmfje6jiw2.%20This%20will%20show%20us%20what%20activity%20in%20that%20storage%20account%20contributed%20the%20most%20to%20the%20cost.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F120538i3E629AC43F448103%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Cost-Hot%20GRS%20write.jpg%22%20title%3D%22Cost-Hot%20GRS%20write.jpg%22%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3EIn%20this%20case%2C%20it%20was%20the%20%E2%80%9Chot%20grs%20write%20operations%E2%80%9D.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E7.%20If%20you%20want%20to%20check%20how%20this%20compares%20to%20previous%20periods%2C%20you%20can%20change%20the%20date%20selector%20in%20this%20view.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F120540i26232BA0FD01526E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Cost-sixmonths.jpg%22%20title%3D%22Cost-sixmonths.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3ELooking%20at%20the%20last%20six%20months%20shows%20there%20was%20a%20significant%20increase%20in%20April.%26nbsp%3BNow%20we%20are%20armed%20with%20some%20more%20information%20to%20start%20a%20conversation%20with%20the%20resource%20owners%2C%20and%20discuss%20if%20this%20cost%20increase%20was%20expected%20and%20if%20it%20will%20affect%20cost%20budgets%20in%20the%20future.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E8.%20That%20custom%20view%20can%20now%20be%20shared%20(via%20a%20URL%20link)%2C%20exported%20to%20CSV%20or%20Excel%2C%20or%20pinned%20to%20your%20Azure%20dashboard%20(which%20will%20update%20as%20new%20cost%20management%20information%20becomes%20available).%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EOther%20Cost%20Analysis%20options%3A%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EAs%20well%20as%20the%20in-built%20Cost%20Analysis%20tool%20(which%20now%20also%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fcost-management%2Faws-integration-manage%3FWT.mc_id%3Ditopstalk-blog-socuff%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Esupports%20AWS%20data%3C%2FA%3E)%2C%20there%20are%20a%20few%20other%20options%20for%20analysing%20your%20Cloud%20consumption%20and%20costs%3A%3C%2FP%3E%0A%3CP%3E-%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Frest%2Fapi%2Fconsumption%2F%3FWT.mc_id%3Ditopstalk-blog-socuff%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%26nbsp%3BAzure%20Consumption%20API%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E-%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Frest%2Fapi%2Fbilling%2F%3FWT.mc_id%3Ditopstalk-blog-socuff%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%26nbsp%3BAzure%20Billing%20API%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E-%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fpower-bi%2Fservice-connect-to-azure-consumption-insights%3FWT.mc_id%3Ditopstalk-blog-socuff%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMicrosoft%20Azure%20Consumption%20Insights%20content%20pack%20for%20Power%20BI%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3ETo%20learn%20more%3A%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EI've%20just%20scratched%20the%20surface%20on%20how%20the%20filters%20and%20grouping%20in%20Cost%20Analysis%20work%2C%20and%20the%20meters%20vary%20depending%20on%20the%20different%20resource%20types.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20more%20Cost%20Management%20resources%2C%20visit%3A%3C%2FP%3E%0A%3CP%3EProduct%20page%20-%20%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fservices%2Fcost-management%2F%3FWT.mc_id%3Ditopstalk-blog-socuff%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Eazure.com%2Fcostmanagement%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EDocumentation%20-%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fcost-management%2F%3FWT.mc_id%3Ditopstalk-blog-socuff%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Eaka.ms%2Fcostmgmt%2Fdocs%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EDemo%20videos%20-%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Faka.ms%2Fcostmgmt%2Fvideos%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Eaka.ms%2Fcostmgmt%2Fvideos%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EMicrosoft%20Learn%20-%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Flearn%2Fmodules%2Fpredict-costs-and-optimize-spending%2F%3FWT.mc_id%3Ditopstalk-blog-socuff%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EPredict%20costs%20and%20optimize%20spending%20for%20Azure%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EAnd%20follow%20the%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2FAzureCostMgmt%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%40AzureCostMgmt%3C%2FA%3E%20Twitter%20account%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CEM%3E-Sonia%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-718890%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20to%20get%20a%20granular%20level%20of%20detail%20on%20what%20resource%20%26amp%3B%20activities%20contributed%20to%20your%20monthly%20Azure%20bill.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20200px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F120536i1C5503933802DBFC%2Fimage-size%2Fsmall%3Fv%3D1.0%26amp%3Bpx%3D200%22%20alt%3D%22CostAnalysisServiceLocation.jpg%22%20title%3D%22CostAnalysisServiceLocation.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-718890%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-721604%22%20slang%3D%22en-US%22%3ERe%3A%20Step-by-Step%3A%20Finding%20and%20Analyzing%20Microsoft%20Azure%20Cloud%20Usage%20Costs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-721604%22%20slang%3D%22en-US%22%3E%3CP%3EDoes%20Cost%20Analysis%20present%20cost%20using%20the%20'retail'%20price%20found%20in%20online%20documentation%20or%20the%20actual%20one%20which%20an%20enterprise-level%20customer%20was%20able%20to%20negotiate%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-721654%22%20slang%3D%22en-US%22%3ERe%3A%20Step-by-Step%3A%20Finding%20and%20Analyzing%20Microsoft%20Azure%20Cloud%20Usage%20Costs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-721654%22%20slang%3D%22en-US%22%3EGreat%20question!%20For%20Enterprise%20Agreements%2C%20subscription%20costs%20are%20based%20on%20usage%20and%20don't%20include%20prepaid%20amounts%2C%20overages%2C%20included%20quantities%2C%20adjustments%2C%20and%20taxes.%20Actual%20charges%20are%20computed%20at%20the%20Enrollment%20level.%3C%2FLINGO-BODY%3E
Microsoft

Have you just seen last months’ bill, or received an alert because you had Azure Budgets configured?

 

If your Cloud spend is different than what you were expecting it to be, you’ll want to do some detective work to isolate the reasons why. While your Azure invoice will detail your consumption of Microsoft’s Azure services, it won’t give you the context of your virtual resource configurations. It’s kind of like asking the electricity company to identify which home appliance used the most power, when you don’t have any smart home metering.


Azure Cost Management’s Cost Analysis tool can help you break down the details. The trick is to change the granularity, grouping and filtering options inside the tool.

 

Prerequisites:
You'll need at least read access to your Azure account and Enterprise Agreement customers will need read access to one or more of the following scopes: Billing account, Department, Enrollment account, Management group, Subscription, Resource Group. Learn more about assigning access to Cost Management data.

 

Steps:

1. Inside the Azure Portal, select Cost Management + Billing.

 

2. Under Cost Management, select Cost analysis.

 

3. I’ve set the Scope to show all the costs for one particular subscription. The scope options you can choose from will depend on what kind of Microsoft agreement (subscription type) you have. Set Granularity to Monthly and Group by Resource type, to see which kinds of resources are contributing the most to your monthly cost.

 

Cost-ResourceType.jpg
You can hover over the colored bars to bring up a list of the associated costs per resource type, at a glance.

 

5. Lets check out the Storage Accounts. Change Group by to Resource and add a filter for Resource Type, selecting microsoft/storage.storage accounts. 

 

cost-dbstorageresource.jpg

 

Now we can see the “dbstorageu35mmfje6jiw2” resource has contributed the most cost during the month of April 2019.

6. Then, set the Group by to Meter, and add a filter for the Resource named dbstorageu35mmfje6jiw2. This will show us what activity in that storage account contributed the most to the cost.

 

Cost-Hot GRS write.jpg

In this case, it was the “hot grs write operations”.

 

7. If you want to check how this compares to previous periods, you can change the date selector in this view.

Cost-sixmonths.jpg

Looking at the last six months shows there was a significant increase in April. Now we are armed with some more information to start a conversation with the resource owners, and discuss if this cost increase was expected and if it will affect cost budgets in the future.

 

8. That custom view can now be shared (via a URL link), exported to CSV or Excel, or pinned to your Azure dashboard (which will update as new cost management information becomes available).

 

Other Cost Analysis options:

As well as the in-built Cost Analysis tool (which now also supports AWS data), there are a few other options for analysing your Cloud consumption and costs:

- Azure Consumption API

- Azure Billing API

- Microsoft Azure Consumption Insights content pack for Power BI

 

To learn more:

I've just scratched the surface on how the filters and grouping in Cost Analysis work, and the meters vary depending on the different resource types. 

 

For more Cost Management resources, visit:

Product page - azure.com/costmanagement

Documentation - aka.ms/costmgmt/docs

Demo videos - aka.ms/costmgmt/videos

Microsoft Learn - Predict costs and optimize spending for Azure

And follow the @AzureCostMgmt Twitter account

 

-Sonia

 

 

 

 

 

 

 

 

 

 

2 Comments
Occasional Visitor

Does Cost Analysis present cost using the 'retail' price found in online documentation or the actual one which an enterprise-level customer was able to negotiate?

Microsoft
Great question! For Enterprise Agreements, subscription costs are based on usage and don't include prepaid amounts, overages, included quantities, adjustments, and taxes. Actual charges are computed at the Enrollment level.