Hi , Welcome to MS Q&A
To calculate the real capacity of your Azure Blob Storage, you can use the Azure Blob Storage inventory feature and Azure Synapse. These tools allow you to calculate the blob count and total size of blobs per container, which can be useful when optimizing blob usage per container. Here are the steps you need to follow:
- Enable inventory reports on your storage account.
- Create an Azure Synapse workspace.
- Create a SQL query to report the inventory results.
You can find detailed steps in the Calculate blob count and total size per container using Azure Storage inventory article.
Another way to monitor the use of a container is to use Azure Storage blob inventory to take an inventory of blobs with size information. Then, you can aggregate the size and count at the container level. For an example, see Calculate blob count and total size per container using Azure Storage inventory.
You can also evaluate traffic at the container level by querying logs. To learn more about writing Log Analytic queries, see Log Analytics. To learn more about the storage logs schema, see Azure Blob Storage monitoring data reference.
References:
Please check and let us know if any questions
Kindly accept answer if it helps
Thanks
Deepanshu