SalesBuy
1-855-856-7678
Technical SupportSupport
Storage Analytics Metrics Table Schema
Storage Analytics Metrics aggregates transaction data and capacity data for a storage account. Transactions metrics are recorded for the Blob, Table, and Queue services. Currently, capacity metrics are only recorded for the Blob service. Transaction data and capacity data is stored in the following tables:
-
$MetricsCapacityBlob
-
$MetricsTransactionsBlob
-
$MetricsTransactionsTable
-
$MetricsTransactionsQueue
 Note |
|---|
| The above tables are not displayed when a listing operation is performed, such as the ListTables method. Each table must be accessed directly. |
The schema for these tables is defined in the following sections. For more information about Metrics, see About Storage Analytics Metrics.
$MetricsCapacityBlob Table Schema
One table is created by Storage Analytics Metrics for blob capacity data:
-
$MetricsCapacityBlob
Two entities will be 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: |
|
|
RowKey |
string |
Indicates whether the capacity table entity applies to user data or Storage Analytics data, in the following format: |
|
|
Capacity |
long |
The amount of storage used by the storage account’s Blob service, in bytes. |
|
|
ContainerCount |
long |
The number of blob containers in the storage account’s Blob service. |
|
|
ObjectCount |
long |
The number of committed and uncommitted blobs in the storage account’s Blob service. |
|
$MetricsTransactions* Table Schema
Three tables are created by Storage Analytics Metrics for transaction data, one for each storage service:
-
$MetricsTransactionsBlob
-
$MetricsTransactionsTable
-
$MetricsTransactionsQueue
Each of these tables uses the same schema to store metrics information. 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 specified by Time (PartitionKey). |
| Column Name | Type | Description | Example |
|---|---|---|---|
|
Time (PartitionKey) |
string |
A timestamp in UTC that represents the starting hour for metrics, in the following format: |
|
|
AccessType and TransactionType (RowKey) |
string |
A combination of AccessType and TransactionType, in the following format:
|
|
|
TotalIngress |
long |
The amount of ingress data, in bytes. This number includes ingress from an external client into Windows Azure Storage as well as ingress within Windows Azure. |
|
|
TotalEgress |
long |
The amount of egress data, in bytes. This number includes egress from an external client into Windows Azure Storage as well as egress within Windows Azure. As a result, this number does not reflect billable egress. |
|
|
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:
For more information on these status messages, see Storage Analytics Logged Operations and Status Messages. |
|
|
TotalBillableRequests |
long |
The number of billable requests. Requests that produce the following status messages are included in this number:
For more information on these status messages, see Storage Analytics Logged Operations and Status Messages. For more information on how billing is provisioned in Windows Azure Storage, see Understanding Windows Azure Storage Billing - Bandwidth, Transactions, and Capacity. |
|
|
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:
For more information on these status messages, see Storage Analytics Logged Operations and Status Messages. |
|
|
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 Windows Azure Storage to read the request, send the response, and receive acknowledgment of the response. |
|
|
AverageServerLatency |
double |
The average latency used by Windows Azure Storage to process a successful request, in milliseconds. This value does not include the network latency specified in AverageE2ELatency. |
|
|
PercentSuccess |
double |
The percentage of successful requests. |
|
|
PercentThrottlingError |
double |
The percentage of requests that failed with a throttling error. |
|
|
PercentTimeoutError |
double |
The percentage of requests that failed with a timeout error. This number includes both client and server timeouts. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
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. |
|
|
ThrottlingError |
long |
The number of authenticated 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. |
|
|
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. |
|
|
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. |
|
|
ClientTimeoutError |
long |
The number of authenticated 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. |
|
|
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. |
|
|
SASClientTimeoutError |
long |
The number of SAS requests to a storage service or the specified API operation that returned an SASClientTimeoutError. For more details about this status message, see Storage Analytics Logged Operations and Status Messages. |
|
|
ServerTimeoutError |
long |
The number of authenticated 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. |
|
|
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. |
|
|
SASServerTimeoutError |
long |
The number of SAS requests to a storage service or the specified API operation that returned an SASServerTimeoutError. For more details about this status message, see Storage Analytics Logged Operations and Status Messages. |
|
|
ClientOtherError |
long |
The number of authenticated 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. |
|
|
SASClientOtherError |
long |
The number of SAS requests to a storage service or the specified API operation that returned an SASClientOtherError. For more details about this status message, see Storage Analytics Logged Operations and Status Messages. |
|
|
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. |
|
|
ServerOtherError |
long |
The number of authenticated 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. |
|
|
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. |
|
|
SASServerOtherError |
long |
The number of SAS requests to a storage service or the specified API operation that returned an SASServerOtherError. For more details about this status message, see Storage Analytics Logged Operations and Status Messages. |
|
|
AuthorizationError |
long |
The number of authenticated 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. |
|
|
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. |
|
|
SASAuthorizationError |
long |
The number of SAS requests to a storage service or the specified API operation that returned an SASAuthorizationError. For more details about this status message, see Storage Analytics Logged Operations and Status Messages. |
|
|
NetworkError |
long |
The number of authenticated 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. |
|
|
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. |
|
|
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. |
|
See Also
