Azure Storage Table size

Question

Azure billing is based on the size of used space. Now I need to know the details. What is the size of each storage object in my storage (blob container, single table)?

It's easy to write a code that enumerates all blobs and calculates the overall size per container. But what about tables? How can I get the size of a certain table in Azure storage?

Answer 1

Here's the Step by Step of how to get this info:

1. Go into "Monitor" in Azure (it's a top level item on the left nav by default), it looks like a speedometer, or perhaps a really fast one handed clock.

2. Then select Metrics (it's below Alerts, and above Logs, in the first grouping).

3. Then from the "Select a scope" pop-up, select your storage account and pressed "Apply".

4. Then on the empty table there are some drop downs, the first one will have the scope you applied. The second one, Metric Namespace, should be "Table", the third one, Metric, should be "Table Capacity", you can leave the last one as Avg -- if you only have one table in your storage account then the Avg will just be the exact size of that table.

5. If you want to calculate the average row size, you can do a simple divide -- in my case I did 1.4 GB / 2.5M entities = ~560 bytes

Answer 2

There is a tool which can get table size or entities count for you. Azure Storage Manager

1. Select a storage table in left tree pane
2. Click 'Property' button
3. Click 'Calc' button on the table properties dialog
4. Wait a few moment, till 'Calc' button becomes available again.