question

YuriyLukashevich-8196 avatar image
0 Votes"
YuriyLukashevich-8196 asked SadiqhAhmed-MSFT answered

Azure CosmosDB - How to get costs report for db account

I'd like to create a report in the Azure portal that will cumulatively show the following information:

Column names:

DB account
Collection name
Provisioned RU Throughput
RUs price per hour
Monthly cost

Rows must contain values.
Totals should be displayed for column 5 .
Default order by DB column 1 ASC.

I've found standard representation on the CosmosDB account's overview tab. Monthly cost column is missing there.

The solution with calculated monthly costs suits me. For example:

DB account Coll. name Prov RU Throug RUs price per hour Monthly cost
db houses 5000 $0.00012/RU 0.00012*5000*24*30=432

Column 'RUs price per hour' could be hardcoded.

I'd appreciate it very much if somebody could share any thoughts on how I can get this report.
I'd like to place it into a workbook or dashboard.

Thank you.

azure-cost-management
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

SadiqhAhmed-MSFT avatar image
0 Votes"
SadiqhAhmed-MSFT answered

@YuriyLukashevich-8196 Thank you for your post and I apologize for the delayed response.

Unfortunately, Azure Cost Management doesn't expose Cosmos DB costs down to the container/collection level. This is feature in work with no confirmed ETA.

The formula to use to convert provisioned throughput into monthly $ costs depends whether you're using autoscale or not.
For autoscale: <throughput> / 100 0.012 730
For manual provisioned throughput: <throughput> / 100 0.008 730

Hope this helps!


If the response helped, do "Accept Answer" and up-vote it

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.