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 |