Storage Analytics metrics table schema (classic)

Note

Storage Analytics metrics are now Classic metrics. Microsoft recommends using Storage Metrics in Azure Monitor instead of Storage Analytics metrics.

Storage Analytics Metrics aggregates transaction data and capacity data for a storage account. Transactions metrics are recorded for the Blob, Table, Queue, and File services. Currently, capacity metrics are only recorded for the Blob service. Transaction data and capacity data are stored in well-known tables, as described in the following table:

Metrics Level Table Names Supported for Versions
Hourly transactions - $MetricsTransactionsBlob

- $MetricsTransactionsTable

- $MetricsTransactionsQueue
Versions prior to 2013-08-15 only. While these names are still supported, it’s recommended that you switch to using the tables listed below.
Hourly transactions - $MetricsHourPrimaryTransactionsBlob

- $MetricsHourPrimaryTransactionsTable

- $MetricsHourPrimaryTransactionsQueue

- $MetricsHourPrimaryTransactionsFile
For the Blob, Table, and Queue services, supported for all versions.

For the File service, supported for version 2015-04-05 and later only.
Minute transactions - $MetricsMinutePrimaryTransactionsBlob

- $MetricsMinutePrimaryTransactionsTable

- $MetricsMinutePrimaryTransactionsQueue

- $MetricsMinutePrimaryTransactionsFile
For the Blob, Table, and Queue services, supported for all versions.

For the File service, supported for version 2015-04-05 and later only.
Hourly metrics, secondary location - $MetricsHourSecondaryTransactionsBlob

- $MetricsHourSecondaryTransactionsTable

- $MetricsHourSecondaryTransactionsQueue
All versions. Read-access geo-redundant replication (RA-GRS) must be enabled.

Note that RA-GRS is not yet available for the File service.
Minute metrics, secondary location - $MetricsMinuteSecondaryTransactionsBlob

- $MetricsMinuteSecondaryTransactionsTable

- $MetricsMinuteSecondaryTransactionsQueue
All versions. Read-access geo-redundant replication (RA-GRS) must be enabled.

Note that RA-GRS is not yet available for the File service.
Capacity (Blob service only) $MetricsCapacityBlob All versions.

Note

The above metrics tables are not displayed when a table listing operation is performed. Each metrics table must be accessed directly based on its name.

The schema for these tables is defined in the following sections. For more information about Metrics, see About Storage Analytics Metrics.

$MetricsCapacityBlob Table Schema

Two entities are stored in the $MetricsCapacityBlob table each day, one summarizing storage account blob and container size details and the other summarizing size details of the $logs container.

Column Name Type Description Example
PartitionKey string A timestamp in UTC that represents the starting hour for metrics, in the following format: YYYYMMddThhmm. Because data is only reported once per day, hhmm (hour and minutes) will always be 0000. This value is the PartitionKey for all entries in the table. 20110809T0000
RowKey string Indicates whether the capacity table entity applies to user data or Storage Analytics data, in the following format: <data¦analytics>. If the value is data, this table entity indicates capacity metrics for user data only. If the value is analytics, this table entity indicates capacity metrics for Storage Analytics data only, specifically the capacity consumed by the $logs blob container. data
Capacity long The amount of storage used by the storage account’s Blob service, in bytes. 488920186
ContainerCount long The number of blob containers in the storage account’s Blob service. 237
ObjectCount long The number of committed and uncommitted blobs in the storage account’s Blob service. 8441

Transactions Table Schema

Each table that stores transaction data, whether by hour or by minute, uses the same schema. Additionally, each table writes two kinds of summary data:

  • Service-level summary data, which contains hourly aggregates for a storage service.
  • API-level summary data, which contains hourly aggregates for a specific API.

Note

Each entry in a table entity only applies to transactions that occurred during the hour (for hourly metrics) or minute (for minute metrics) specified by Time (PartitionKey).

Column Name Type Description Example
Time (PartitionKey) string For hour metrics, a timestamp in UTC that represents the starting hour for metrics, in the following format: YYYYMMddThhmm. This value is the partition key for all entries in the table. For minute metrics, the format is the same, but the minute value is an approximate indication of the time when the transactions were executed. Transactions from earlier minutes may be aggregated into the transaction for the current minute if they were missed in the previous interval. 20110809T0800
AccessType and TransactionType (RowKey) string A combination of AccessType and TransactionType, in the following format: <user¦system>;<all¦api-name>. These values comprise the RowKey for an individual table entity. The following list describes the values of each type:

- user is specified for all user requests, including anonymous, authorized, and SAS requests.

- system is specified only for requests from Storage Analytics.

- all is specified if the table entity is a summary of all requests made to the storage service.

- api-name indicates the applicable operation for the summary entity. For a list of possible operations, see Storage Analytics Logged Operations and Status Messages.
user;GetBlob
TotalIngress long The amount of ingress data, in bytes. This number includes ingress from an external client into Azure Storage as well as ingress within Azure. 28395
TotalEgress long The amount of egress data, in bytes. This number includes egress from an external client into Azure Storage as well as egress within Azure. As a result, this number does not reflect billable egress. 8021
TotalRequests long The number of requests made to a storage service or the specified API operation. This number includes successful and failed requests, as well as requests which produced errors. Requests that produce the following status messages are included in this number:

Status Messages (Blob, Queue, Table, File)

- Success

- AnonymousSuccess

- SASSuccess

- ThrottlingError

- AnonymousThrottlingError

- SASThrottlingError

- NetworkError

- AnonymousNetworkError

- SASNetworkError

- ClientOtherError

- AnonymousClientOtherError

- SASClientOtherError

- ServerOtherError

- AnonymousServerOtherError

- SASServerOtherError

- ClientTimeoutError

- AnonymousClientTimeoutError

- SASClientTimeoutError

- ServerTimeoutError

- AnonymousServerTimeoutError

- SASServerTimeoutError

- AuthorizationError

- AnonymousAuthorizationError

- SASAuthorizationError

Status Messages (File SMB)

- Negotiate

- SessionSetup

- Logoff

- TreeConnect

- TreeDisconnect

- Create

- Close

- Flush

- Read

- Write

- Lock

- Ioctl

- Cancel

- Echo

- QueryDirectory

- ChangeNotify

- QueryInfo

- SetInfo

- OplockBreak

For more information on these status messages, see Storage Analytics Logged Operations and Status Messages.
20914
TotalBillableRequests long The number of billable requests. Requests that produce the following status messages are included in this number:

Status Messages (Blob, Queue, Table, File)

- Success

- AnonymousSuccess

- SASSuccess

- NetworkError

- AnonymousNetworkError

- SASNetworkError

- ClientOtherError

- AnonymousClientOtherError

- SASClientOtherError

- ClientTimeoutError

- AnonymousClientTimeoutError

- SASClientTimeoutError

- AuthorizationError

- SASAuthorizationError

Status Messages (File SMB)

- Negotiate

- SessionSetup

- Logoff

- TreeConnect

- TreeDisconnect

- Create

- Close

- Flush

- Read

- Write

- Lock

- Ioctl

- Cancel

- Echo

- QueryDirectory

- ChangeNotify

- QueryInfo

- SetInfo

- OplockBreak

For more information on these status messages, see Storage Analytics Logged Operations and Status Messages.
14297
Availability double The percentage of availability for the storage service or the specified API operation. Availability is calculated by taking the TotalBillableRequests value and dividing it by the number of applicable requests, including those that produced unexpected errors. All unexpected errors result in reduced availability for the storage service or the specified API operation. Requests that produce the following status messages are included in this percentage:

Status Messages (Blob, Queue, Table, File)

- Success

- AnonymousSuccess

- SASSuccess

- NetworkError

- AnonymousNetworkError

- SASNetworkError

- ClientOtherError

- AnonymousClientOtherError

- SASClientOtherError

- ServerOtherError

- AnonymousServerOtherError

- SASServerOtherError

- ClientTimeoutError

- AnonymousClientTimeoutError

- SASClientTimeoutError

- ServerTimeoutError

- AnonymousServerTimeoutError

- SASServerTimeoutError

- AuthorizationError

- SASAuthorizationError

Status Messages (File SMB)

- Negotiate

- SessionSetup

- Logoff

- TreeConnect

- TreeDisconnect

- Create

- Close

- Flush

- Read

- Write

- Lock

- Ioctl

- Cancel

- Echo

- QueryDirectory

- ChangeNotify

- QueryInfo

- SetInfo

- OplockBreak

For more information on these status messages, see Storage Analytics Logged Operations and Status Messages.
99.99
AverageE2ELatency double The average end-to-end latency of successful requests made to a storage service or the specified API operation, in milliseconds. This value includes the required processing time within Azure Storage to read the request, send the response, and receive acknowledgment of the response. 19.333333
AverageServerLatency double The average latency used by Azure Storage to process a successful request, in milliseconds. This value does not include the network latency specified in AverageE2ELatency. 11.4
PercentSuccess double The percentage of successful requests.

Note that if there are no requests made against storage, the value of the PercentSuccess metric will be zero. If you are monitoring PercentSuccess, you will also want to ensure that the value of the TotalRequests metric is greater than zero.
68
PercentThrottlingError double The percentage of requests that failed with a throttling error. 0
PercentTimeoutError double The percentage of requests that failed with a timeout error. This number includes both client and server timeouts. 0
PercentServerOtherError double The percentage of requests that failed with a ServerOtherError. For more information on this status message, see Storage Analytics Logged Operations and Status Messages. 0
PercentClientOtherError double The percentage of requests that failed with a ClientOtherError. For more details about this status message, see Storage Analytics Logged Operations and Status Messages. 0
PercentAuthorizationError double The percentage of requests that failed with an AuthorizationError. For more details about this status message, see Storage Analytics Logged Operations and Status Messages. 0
PercentNetworkError double The percentage of requests that failed with a NetworkError. For more details about this status message, see Storage Analytics Logged Operations and Status Messages. 0
Success long The number of successful requests made to a storage service or the specified API operation. For more details about this status message, see Storage Analytics Logged Operations and Status Messages. 10239
AnonymousSuccess long The number of successful anonymous requests made to a storage service or the specified API operation. For more details about this status message, see Storage Analytics Logged Operations and Status Messages. 8239
SASSuccess long The number of successful Shared Access Signature (SAS) requests made to a storage service or the specified API operation. For more details about this status message, see Storage Analytics Logged Operations and Status Messages. 432
ThrottlingError long The number of authorized requests to a storage service or the specified API operation that returned a ThrottlingError. For more details about this status message, see Storage Analytics Logged Operations and Status Messages. 0
AnonymousThrottlingError long The number of anonymous requests to a storage service or the specified API operation that returned an AnonymousThrottlingError. For more details about this status message, see Storage Analytics Logged Operations and Status Messages. 0
SASThrottlingError long The number of SAS requests to a storage service or the specified API operation that returned a SASThrottlingError. For more details about this status message, see Storage Analytics Logged Operations and Status Messages. 0
ClientTimeoutError long The number of authorized requests to a storage service or the specified API operation that returned a ClientTimeoutError. For more details about this status message, see Storage Analytics Logged Operations and Status Messages. 0
AnonymousClientTimeoutError long The number of anonymous requests to a storage service or the specified API operation that returned an AnonymousClientTimeoutError. For more details about this status message, see Storage Analytics Logged Operations and Status Messages. 0
SASClientTimeoutError long The number of SAS requests to a storage service or the specified API operation that returned a SASClientTimeoutError. For more details about this status message, see Storage Analytics Logged Operations and Status Messages. 0
ServerTimeoutError long The number of authorized requests to a storage service or the specified API operation that returned a ServerTimeoutError. For more details about this status message, see Storage Analytics Logged Operations and Status Messages. 0
AnonymousServerTimeoutError long The number of anonymous requests to a storage service or the specified API operation that returned an AnonymousServerTimeoutError. For more details about this status message, see Storage Analytics Logged Operations and Status Messages. 0
SASServerTimeoutError long The number of SAS requests to a storage service or the specified API operation that returned a SASServerTimeoutError. For more details about this status message, see Storage Analytics Logged Operations and Status Messages. 0
ClientOtherError long The number of authorized requests to a storage service or the specified API operation that returned a ClientOtherError. For more details about this status message, see Storage Analytics Logged Operations and Status Messages. 0
SASClientOtherError long The number of SAS requests to a storage service or the specified API operation that returned a SASClientOtherError. For more details about this status message, see Storage Analytics Logged Operations and Status Messages. 0
AnonymousClientOtherError long The number of anonymous requests to a storage service or the specified API operation that returned an AnonymousClientOtherError. For more details about this status message, see Storage Analytics Logged Operations and Status Messages. 0
ServerOtherError long The number of authorized requests to a storage service or the specified API operation that returned a ServerOtherError. For more details about this status message, see Storage Analytics Logged Operations and Status Messages. 0
AnonymousServerOtherError long The number of anonymous requests to a storage service or the specified API operation that returned an AnonymousServerOtherError. For more details about this status message, see Storage Analytics Logged Operations and Status Messages. 0
SASServerOtherError long The number of SAS requests to a storage service or the specified API operation that returned a SASServerOtherError. For more details about this status message, see Storage Analytics Logged Operations and Status Messages. 0
AuthorizationError long The number of authorized requests to a storage service or the specified API operation that returned an AuthorizationError. For more details about this status message, see Storage Analytics Logged Operations and Status Messages. 0
AnonymousAuthorizationError long The number of anonymous requests to a storage service or the specified API operation that returned an AnonymousAuthorizationError. For more details about this status message, see Storage Analytics Logged Operations and Status Messages. 0
SASAuthorizationError long The number of SAS requests to a storage service or the specified API operation that returned a SASAuthorizationError. For more details about this status message, see Storage Analytics Logged Operations and Status Messages. 0
NetworkError long The number of authorized requests to a storage service or the specified API operation that returned a NetworkError. For more details about this status message, see Storage Analytics Logged Operations and Status Messages. 0
AnonymousNetworkError long The number of anonymous requests to a storage service or the specified API operation that returned an AnonymousNetworkError. For more details about this status message, see Storage Analytics Logged Operations and Status Messages. 0
SASNetworkError long The number of SAS requests to a storage service or the specified API operation that returned a SASNetworkError. For more details about this status message, see Storage Analytics Logged Operations and Status Messages. 0

See Also