Storage Account 400Gb

Sebastien Soum 0 Reputation points
2023-08-09T01:33:03.1233333+00:00

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

Azure Storage
Azure Storage
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
3,543 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Dillon Silzer 57,831 Reputation points Volunteer Moderator
    2023-08-09T02:17:03.7133333+00:00

    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.

    0 comments No comments

  2. Sumarigo-MSFT 47,471 Reputation points Microsoft Employee Moderator
    2023-08-11T09:38:23.93+00:00

    @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.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.