How to calculate the read/write SLA of storage accounts

Adriaan Suls 1 Reputation point
2021-04-30T09:27:01.587+00:00

I am working on an Azure Monitor Workbook to display the actual SLA status of all resources (using Function Apps to do the calculations and Storage Tables to store the intermediate data).
For storage accounts MS gives 2 SLA values: one for processed read requests and one for processed write requests (with write requests having a lower SLA than read requests).

https://azure.microsoft.com/en-us/support/legal/sla/storage/v1_5/

When I want to calculate what the actual values of the monthly uptime percentage for read and write requests are for a given storage account, I don't know where to find these values. In the metrics of a storage account I find the metric 'Availability' which, according to the MS explanation, gives the total number of billablerequests divided by the total number of actual requests (including failed ones). This metric however does not make any distinction between read or write. Can anyone tell me where I can find the specific values of succeeded/failed/total read requests and succeeded/failed/total write requests for a storage account?

Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
2,721 questions
Azure AI Metrics Advisor
Azure AI Metrics Advisor
An Azure artificial intelligence analytics service that proactively monitors metrics and diagnoses issues.
80 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Sumarigo-MSFT 43,806 Reputation points Microsoft Employee
    2021-05-03T08:43:28.387+00:00

    @Adriaan Suls Thanks for raising this question! Firstly, apologies for the delay in responding here and any inconvenience this issue may have caused. Kindly try the following steps to isolate the issue:
    Same "Availability" metric gives availability by API name where you can understand whether its read or write based on namespace category.

    93229-image.png

    Also, using resource logs that is in preview you can check read and write category info.

    93230-image.png

    For more information, please refer to this article: https://learn.microsoft.com/en-us/azure/storage/blobs/monitor-blob-storage-reference#transaction-metrics

    Hope this helps!

    Kindly let us know if the above helps or you need further assistance on this issue.

    ----------------------------------------------------------------------------------------------------------------------------------------------------------

    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
  2. Adriaan Suls 1 Reputation point
    2021-05-04T14:03:56.577+00:00

    Hey, thanks for the quick response.
    I am still a bit unclear as how to actually calculate these read and write values.
    Do you mean to say that I have to look at the different NameSpaces in those metrics and look at which ones are write operations and which ones are read operations and then add all those categories together? E.g. read: ListContainers, GetContainerACL, ... and write: CreateContainer, PutBlob, ...

    If this is correct, is there any documentation on what different namespaces exist so that I can have a complete list to implement in my code? I did not find that data yet on the link you posted.

    0 comments