Storage Account 400Gb

Question

hi there

we use Azure for lots of different things. One of those is storing of large volume of XML files in Blob storage in various containers

our storager account is using 400gb. Ive tried deleting 1000's of XML files, but its not affected the size of my storage

how can I identify where the largest files are ? the storage explorer doesnt seem to have this option

Answer 1

Hello Sebastien,

#1 Have a look at the following video (where everything is explained using AzCopy and a simple script):

How to get the list of Files and Size from Azure Blob Storage and Save into CSV File by AzCopy

https://youtube.com/watch?v=5aw0CpASnfU

#2 You can look at using Azure Storage Explorer:

https://azure.microsoft.com/en-ca/products/storage/storage-explorer

---

If this is helpful please accept answer.

Answer 2

@Sebastien Soum Welcome to Microsoft Q&A Forum, Thank you for posting your query here!

As I understand you need to Calculate the size/capacity of storage account and it services (Blob/Table)

How to get the total size allocated to a Storage account and the for types like Queues, tables, blobs and files.

This article uses the Azure Blob Storage inventory feature and Azure Synapse to calculate the blob count and total size of blobs per container. These values are useful when optimizing blob usage per container. Calculate blob count and total size per container using Azure Storage inventory

You can use the below CLi command and followed Microsoft-Document as below:

az storage blob list --account-name xx --container-name yy

Get report of file sizes from Azure Blob Storage

How to get Azure Blob file size

You can use Azure Storage Analytics to identify the largest files in your Blob storag. Storage Analytics provides detailed metrics and logs that you can use to monitor and troubleshoot your storage account. Here are the steps to enable Storage Analytics and view the metrics:

1. Enable Storage Analytics: In the Azure portal, navigate to your storage account. Select the "Monitoring" tab, and then select "Storage Analytics". Click "Add policy" to create a new policy. Choose the metrics and logs you want to collect, and then click "Save".
2. View the metrics: In the Azure portal, navigate to your storage account. Select the "Monitoring" tab, and then select "Metrics". Choose the metrics you want to view, and then select the time range you want to view. You can view the metrics for the entire storage account or for individual containers.

Identify the largest files: In the metrics view, you can see the total size of your Blob storage and the number of blobs in each container. You can use this information to identify the containers that are using the most storage. To identify the largest files within a container, you can use a tool like Azure Storage Explorer or Azure CLI to sort the blobs by size.

Please let us know if you have any further queries. I’m happy to assist you further.

---

Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.