1. Calculate the capacity of all the storage account at the subscription level – via Portal .
To view the utilization and availability of your storage accounts across all of your subscriptions, perform the following steps.
IV. Select “Capacity”
For more details, please visit here : https://docs.microsoft.com/en-us/azure/azure-monitor/insights/storage-insights-overview#view-from-az...
2. Calculate the capacity at the single storage account and different service level (Blob/Queue/Table/File) – via Portal.
iv. Select the Capacity
For more details , please visit here : https://docs.microsoft.com/en-us/azure/azure-monitor/insights/storage-insights-overview#view-from-a-...
3. Calculate the size of a Blob storage container – via PowerShell
This script calculates the size of a container in Azure Blob storage by totaling the size of the blobs in the container.
For more details , please visit here : https://docs.microsoft.com/en-us/azure/storage/scripts/storage-blobs-container-calculate-size-powers...
Script that calculates container size for billing purposes, see Calculate the size of a Blob storage container for billing purposes
4. Calculate the size of a Blob storage container - via Azure CLI
This script calculates the size of a container in Azure Blob storage by totaling the size of the blobs in the container.
5. Calculate the size of a Blob storage container – via Storage explorer
6. Calculate Table storage entity count – via Storage explorer
7. Calculate Table storage entity count – via PowerShell
$connectionString = "Connection String of your storage account"
$context = New-AzureStorageContext -ConnectionString $connectionString
$azureStorageTable = Get-AzureStorageTable -Context $context
function GetTableCount($table)
{
#Create a table query.
$query = New-Object Microsoft.WindowsAzure.Storage.Table.TableQuery
#Define columns to select.
$list = New-Object System.Collections.Generic.List[string]
$list.Add("PartitionKey")
#Set query details.
$query.SelectColumns = $list
#Execute the query.
$entities = $table.CloudTable.ExecuteQuery($query)
($entities | measure).Count
}
foreach ($table in $azureStorageTable)
{
"Table name :"+ $table.Name
GetTableCount $table
}
"Total number of tables : " + $azureStorageTable.Count
8. Calculate the size of each entity in azure storage table.
The following expressions shows how to estimate the amount of storage consumed per entity:
Total Entity Size:
The following is the breakdown:
The Sizeof(.Net Property Type) for the different types is:
Note:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.