Home
%3CLINGO-SUB%20id%3D%22lingo-sub-1064046%22%20slang%3D%22en-US%22%3ECalculate%20the%20size%2Fcapacity%20of%20storage%20account%20and%20it%20services%20(Blob%2FTable)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1064046%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3E1.%20Calculate%20the%20capacity%20of%20%3CFONT%20color%3D%22%23FF9900%22%3Eall%20the%20storage%3C%2FFONT%3E%20account%20at%20the%20subscription%20level%20%E2%80%93%20via%20%3CFONT%20color%3D%22%23FF9900%22%3EPortal%3C%2FFONT%3E%20.%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%26nbsp%3B%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%20%26nbsp%3BTo%20view%20the%20utilization%20and%20availability%20of%20your%20storage%20accounts%20across%20all%20of%20your%20subscriptions%2C%20perform%20the%20following%20steps.%3C%2FP%3E%0A%3COL%20style%3D%22list-style-type%3A%20lower-roman%3B%22%3E%0A%3CLI%3ESign%20in%20to%20the%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fportal.azure.com%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAzure%20portal%3C%2FA%3E.%3C%2FLI%3E%0A%3CLI%3ESelect%26nbsp%3B%3CSTRONG%3E%3CEM%3EMonitor%3C%2FEM%3E%3C%2FSTRONG%3E%26nbsp%3Bfrom%20the%20left-hand%20pane%20in%20the%20Azure%20portal%2C%20and%3C%2FLI%3E%0A%3CLI%3EUnder%20the%26nbsp%3B%3CSTRONG%3E%3CEM%3EInsights%3C%2FEM%3E%3C%2FSTRONG%3E%26nbsp%3Bsection%2C%20select%26nbsp%3B%3CSTRONG%3E%3CEM%3EStorage%20Accounts%20(%3C%2FEM%3E%3C%2FSTRONG%3E%3CSTRONG%3E%3CEM%3Epreview%3C%2FEM%3E%3C%2FSTRONG%3E%3CSTRONG%3E%3CEM%3E)%3C%2FEM%3E%3C%2FSTRONG%3E%3CSTRONG%3E.%3C%2FSTRONG%3E%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F161582iEA0BD03E9EC8F983%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%20%26nbsp%3B%20IV.%20Select%20%E2%80%9C%3CEM%3ECapacity%3C%2FEM%3E%E2%80%9D%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F161583i828998E6A056360A%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_1.png%22%20title%3D%22clipboard_image_1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20For%20more%20details%2C%20please%20visit%20here%20%26nbsp%3B%3A%26nbsp%3B%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-monitor%2Finsights%2Fstorage-insights-overview%23view-from-azure-monitor%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-monitor%2Finsights%2Fstorage-insights-overview%23view-from-azure-monitor%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E2.%20Calculate%20the%20capacity%20%3CFONT%20color%3D%22%23FF9900%22%3Eat%20the%20single%20storage%20account%3C%2FFONT%3E%20and%20different%20service%20level%20(Blob%2FQueue%2FTable%2FFile)%20%E2%80%93%20via%20%3CFONT%20color%3D%22%23FF9900%22%3EPortal%3C%2FFONT%3E%3C%2FSTRONG%3E.%3C%2FP%3E%0A%3COL%20style%3D%22list-style-type%3A%20lower-roman%3B%22%3E%0A%3CLI%3EIn%20the%20Azure%20portal%2C%20select%20Storage%20accounts.%3C%2FLI%3E%0A%3CLI%3EFrom%20the%20list%2C%20choose%20a%20storage%20account.%3C%2FLI%3E%0A%3CLI%3EIn%20the%20Monitoring%20section%2C%20choose%20%3CEM%3EInsights%20(preview)%3C%2FEM%3E.%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F161584i40B61E36755E007F%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_2.png%22%20title%3D%22clipboard_image_2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eiv.%20Select%20the%20Capacity%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F161585iB2072E4A32098350%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_3.png%22%20title%3D%22clipboard_image_3.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20more%20details%20%2C%20please%20visit%20here%20%3A%26nbsp%3B%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-monitor%2Finsights%2Fstorage-insights-overview%23view-from-a-storage-account%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-monitor%2Finsights%2Fstorage-insights-overview%23view-from-a-storage-account%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E3.%20Calculate%20the%20size%20of%20a%20Blob%20storage%20container%20%E2%80%93%20%3CFONT%20color%3D%22%23FF9900%22%3Evia%20PowerShell%3C%2FFONT%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20script%20calculates%20the%20size%20of%20a%20container%20in%20Azure%20Blob%20storage%20by%20totaling%20the%20size%20of%20the%20blobs%20in%20the%20container.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20more%20details%20%2C%20please%20visit%20here%20%3A%26nbsp%3B%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fstorage%2Fscripts%2Fstorage-blobs-container-calculate-size-powershell%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fstorage%2Fscripts%2Fstorage-blobs-container-calculate-size-powershell%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EScript%20that%20calculates%20container%20size%20for%20billing%20purposes%2C%20see%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fstorage%2Fscripts%2Fstorage-blobs-container-calculate-billing-size-powershell%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3ECalculate%20the%20size%20of%20a%20Blob%20storage%20container%20for%20billing%20purposes%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E4.%20Calculate%20the%20size%20of%20a%20Blob%20storage%20container%20-%3CFONT%20color%3D%22%23FF9900%22%3E%20via%20Azure%20CLI%3C%2FFONT%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3EThis%20script%20calculates%20the%20size%20of%20a%20container%20in%20Azure%20Blob%20storage%20by%20totaling%20the%20size%20of%20the%20blobs%20in%20the%20container.%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fstorage%2Fscripts%2Fstorage-blobs-container-calculate-size-cli%23sample-script%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fstorage%2Fscripts%2Fstorage-blobs-container-calculate-size-cli%23sample-script%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E5.%20Calculate%20the%20size%20of%20a%20Blob%20storage%20container%20%E2%80%93%20via%20%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-in%2Ffeatures%2Fstorage-explorer%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EStorage%20explorer%3C%2FA%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3COL%20style%3D%22list-style-type%3A%20lower-roman%3B%22%3E%0A%3CLI%3ESign-in%20to%20azure%20storage%20explorer%20using%20any%20of%20the%20approach%20mentioned%20here%26nbsp%3B%20-%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fvs-azure-tools-storage-manage-with-storage-explorer%3Ftabs%3Dwindows%23sign-in-to-azure%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fvs-azure-tools-storage-manage-with-storage-explorer%3Ftabs%3Dwindows%23sign-in-to-azure%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3ESelect%20the%20storage%20of%20your%20interest.%3C%2FLI%3E%0A%3CLI%3ESelect%20the%20container.%3C%2FLI%3E%0A%3CLI%3EClick%20%E2%80%9CFolder%20Statistics%E2%80%9D%20button.%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F161586i850934D6D5D9DEE3%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_4.png%22%20title%3D%22clipboard_image_4.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E6.%20Calculate%20Table%20storage%20entity%20count%20%E2%80%93%20%3CFONT%20color%3D%22%23FF9900%22%3Evia%20%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-in%2Ffeatures%2Fstorage-explorer%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EStorage%20explorer%3C%2FA%3E%3C%2FFONT%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3COL%20style%3D%22list-style-type%3A%20lower-roman%3B%22%3E%0A%3CLI%3ESign-in%20to%20azure%20storage%20explorer%20using%20any%20of%20the%20approach%20mentioned%20here%26nbsp%3B%20-%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fvs-azure-tools-storage-manage-with-storage-explorer%3Ftabs%3Dwindows%23sign-in-to-azure%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fvs-azure-tools-storage-manage-with-storage-explorer%3Ftabs%3Dwindows%23sign-in-to-azure%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3ESelect%20the%20storage%20of%20your%20interest.%3C%2FLI%3E%0A%3CLI%3ESelect%20the%20Table.%3C%2FLI%3E%0A%3CLI%3EClick%20%E2%80%9CTable%20Statistics%E2%80%9D.%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F161587i3C451060F7A93C83%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_5.png%22%20title%3D%22clipboard_image_5.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E7.%20Calculate%20Table%20storage%20entity%20count%20%E2%80%93%20%3CFONT%20color%3D%22%23FF9900%22%3Evia%3C%2FFONT%3E%20%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-in%2Ffeatures%2Fstorage-explorer%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EPowerShell%3C%2FA%3E%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%24connectionString%20%3D%20%22Connection%20String%20of%20your%20storage%20account%22%3C%2FP%3E%0A%3CP%3E%24context%20%3D%20New-AzureStorageContext%20-ConnectionString%20%24connectionString%3C%2FP%3E%0A%3CP%3E%24azureStorageTable%20%3D%20Get-AzureStorageTable%20-Context%20%24context%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Efunction%20GetTableCount(%24table)%3C%2FP%3E%0A%3CP%3E%7B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%23Create%20a%20table%20query.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%24query%20%3D%20New-Object%20Microsoft.WindowsAzure.Storage.Table.TableQuery%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%23Define%20columns%20to%20select.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%24list%20%3D%20New-Object%20System.Collections.Generic.List%5Bstring%5D%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%24list.Add(%22PartitionKey%22)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%23Set%20query%20details.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%24query.SelectColumns%20%3D%20%24list%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%23Execute%20the%20query.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%24entities%20%3D%20%24table.CloudTable.ExecuteQuery(%24query)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%20(%24entities%20%7C%20measure).Count%3C%2FP%3E%0A%3CP%3E%7D%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eforeach%20(%24table%20in%20%24azureStorageTable)%3C%2FP%3E%0A%3CP%3E%7B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%22Table%20name%20%3A%22%2B%20%24table.Name%26nbsp%3B%3C%2FP%3E%0A%3CP%3EGetTableCount%20%24table%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%7D%3C%2FP%3E%0A%3CP%3E%22Total%20number%20of%20tables%20%3A%20%22%20%2B%20%24azureStorageTable.Count%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E8.%20Calculate%20the%20size%20of%20each%20entity%20in%20azure%20storage%20table.%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20following%20expressions%20shows%20how%20to%20estimate%20the%20amount%20of%20storage%20consumed%20per%20entity%3A%3C%2FP%3E%0A%3CP%3ETotal%20Entity%20Size%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E4%20bytes%20%2B%20Len%20(PartitionKey%20%2B%20RowKey)%20*%202%20bytes%20%2B%20For-Each%20Property(8%20bytes%20%2B%20Len(Property%20Name)%20*%202%20bytes%20%2B%20Sizeof(.Net%20Property%20Type))%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20following%20is%20the%20breakdown%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E4%20bytes%20overhead%20for%20each%20entity%2C%20which%20includes%20the%20Timestamp%2C%20along%20with%20some%20system%20metadata.%3C%2FLI%3E%0A%3CLI%3EThe%20number%20of%20characters%20in%20the%20PartitionKey%20and%20RowKey%20values%2C%20which%20are%20stored%20as%20Unicode%20(times%202%20bytes).%3C%2FLI%3E%0A%3CLI%3EThen%20for%20each%20property%20we%20have%20an%208%20byte%20overhead%2C%20plus%20the%20name%20of%20the%20property%20*%202%20bytes%2C%20plus%20the%20size%20of%20the%20property%20type%20as%20derived%20from%20the%20list%20below.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3BThe%20Sizeof(.Net%20Property%20Type)%20for%20the%20different%20types%20is%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EString%20%E2%80%93%20%23%20of%20Characters%20*%202%20bytes%20%2B%204%20bytes%20for%20length%20of%20string%3C%2FLI%3E%0A%3CLI%3EDateTime%20%E2%80%93%208%20bytes%3C%2FLI%3E%0A%3CLI%3EGUID%20%E2%80%93%2016%20bytes%3C%2FLI%3E%0A%3CLI%3EDouble%20%E2%80%93%208%20bytes%3C%2FLI%3E%0A%3CLI%3EInt%20%E2%80%93%204%20bytes%3C%2FLI%3E%0A%3CLI%3EINT64%20%E2%80%93%208%20bytes%3C%2FLI%3E%0A%3CLI%3EBool%20%E2%80%93%201%20byte%3C%2FLI%3E%0A%3CLI%3EBinary%20%E2%80%93%20sizeof(value)%20in%20bytes%20%2B%204%20bytes%20for%20length%20of%20binary%20array%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3ENote%3A%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3EWe%20do%20not%20have%20inbuilt%20feature%20to%20calculate%20the%20size%20of%20individual%20table%2C%20to%20do%20that%20you%20would%20need%20to%20write%20your%20own%20script%20to%20calculate%20the%20size%20of%20individual%20entity%20i.e.%20%26nbsp%3BSize%20of%20storage%20table%20%3D%20Sum%20of%20all%20the%20individual%20entity%20in%20given%20storage%20table.%26nbsp%3B%20(Any%20type%20of%20operation%20against%20the%20storage%20is%20counted%20as%20a%20transaction%2C%20including%20reads%2C%20writes%20and%20deletes%20and%20hence%20it%20would%20be%20charged.%20For%20more%20details%2C%20please%20visit%20here%20%26nbsp%3B-%20%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-in%2Fpricing%2Fdetails%2Fstorage%2Ftables%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fazure.microsoft.com%2Fen-in%2Fpricing%2Fdetails%2Fstorage%2Ftables%2F%3C%2FA%3E%20)%3C%2FLI%3E%0A%3C%2FOL%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1064046%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20would%20be%20the%20one%20stop%20place%20to%20calculate%20the%20size%2Fcapacity%20of%20storage%20account%20and%20its%20services%20(Blob%2FTable)%20at%20various%20level%20(such%20as%20Subscription%2C%20Storage%20account%20and%20Container%20level).%20%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-TEASER%3E
Microsoft

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.

  1. Sign in to the Azure portal.
  2. Select Monitor from the left-hand pane in the Azure portal, and
  3. Under the Insights section, select Storage Accounts (preview).

clipboard_image_0.png

    IV. Select “Capacity

 

clipboard_image_1.png

               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.

  1. In the Azure portal, select Storage accounts.
  2. From the list, choose a storage account.
  3. In the Monitoring section, choose Insights (preview).

clipboard_image_2.png

iv. Select the Capacity

clipboard_image_3.png

 

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.

https://docs.microsoft.com/en-us/azure/storage/scripts/storage-blobs-container-calculate-size-cli#sa...

 

5. Calculate the size of a Blob storage container – via Storage explorer

 

  1. Sign-in to azure storage explorer using any of the approach mentioned here  - https://docs.microsoft.com/en-us/azure/vs-azure-tools-storage-manage-with-storage-explorer?tabs=wind...
  2. Select the storage of your interest.
  3. Select the container.
  4. Click “Folder Statistics” button.

clipboard_image_4.png

 

6. Calculate Table storage entity count – via Storage explorer

  1. Sign-in to azure storage explorer using any of the approach mentioned here  - https://docs.microsoft.com/en-us/azure/vs-azure-tools-storage-manage-with-storage-explorer?tabs=wind...
  2. Select the storage of your interest.
  3. Select the Table.
  4. Click “Table Statistics”.

clipboard_image_5.png

 

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:

  • 4 bytes + Len (PartitionKey + RowKey) * 2 bytes + For-Each Property(8 bytes + Len(Property Name) * 2 bytes + Sizeof(.Net Property Type))

 

The following is the breakdown:

  • 4 bytes overhead for each entity, which includes the Timestamp, along with some system metadata.
  • The number of characters in the PartitionKey and RowKey values, which are stored as Unicode (times 2 bytes).
  • Then for each property we have an 8 byte overhead, plus the name of the property * 2 bytes, plus the size of the property type as derived from the list below.

 The Sizeof(.Net Property Type) for the different types is:

  • String – # of Characters * 2 bytes + 4 bytes for length of string
  • DateTime – 8 bytes
  • GUID – 16 bytes
  • Double – 8 bytes
  • Int – 4 bytes
  • INT64 – 8 bytes
  • Bool – 1 byte
  • Binary – sizeof(value) in bytes + 4 bytes for length of binary array

Note:

  1. We do not have inbuilt feature to calculate the size of individual table, to do that you would need to write your own script to calculate the size of individual entity i.e.  Size of storage table = Sum of all the individual entity in given storage table.  (Any type of operation against the storage is counted as a transaction, including reads, writes and deletes and hence it would be charged. For more details, please visit here  - https://azure.microsoft.com/en-in/pricing/details/storage/tables/ )