Exportera (0) Skriv ut
Visa allt
EN
Det här innehållet finns inte tillgängligt på ditt språk men här finns den engelska versionen,

Storage Analytics Metrics Table Schema

Updated: December 12, 2013

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 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

All versions, including 2013-08-15

Minute transactions

  • $MetricsMinutePrimaryTransactionsBlob

  • $MetricsMinutePrimaryTransactionsTable

  • $MetricsMinutePrimaryTransactionsQueue

All versions, including 2013-08-15

Hourly metrics, secondary location

  • $MetricsHourSecondaryTransactionsBlob

  • $MetricsHourSecondaryTransactionsTable

  • $MetricsHourSecondaryTransactionsQueue

All versions, including 2013-08-15. Read-access geo-redundant replication must be enabled.

Minute metrics, secondary location

  • $MetricsMinuteSecondaryTransactionsBlob

  • $MetricsMinuteSecondaryTransactionsTable

  • $MetricsMinuteSecondaryTransactionsQueue

All versions, including 2013-08-15. Read-access geo-redundant replication must be enabled.

Capacity (Blob service only)

$MetricsCapacityBlob

All versions, including 2013-08-15

noteNote
The above tables are not displayed when a listing operation is performed, such as the ListTables method. Each metrics 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.

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

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.

noteNote
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, authenticated, 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 Windows Azure Storage as well as ingress within Windows Azure.

28395

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.

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:

  • Success

  • AnonymousSuccess

  • SASSuccess

  • ThrottlingError

  • AnonymousThrottlingError

  • SASThrottlingError

  • NetworkError

  • AnonymousNetworkError

  • SASNetworkError

  • ClientOtherError

  • AnonymousClientOtherError

  • SASClientOtherError

  • ServerOtherError

  • AnonymousServerOtherError

  • SASServerOtherError

  • ClientTimeoutError

  • AnonymousClientTimeoutError

  • SASClientTimeoutError

  • ServerTimeoutError

  • AnonymousServerTimeoutError

  • SASServerTimeoutError

  • AuthorizationError

  • AnonymousAuthorizationError

  • SASAuthorizationError

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:

  • Success

  • AnonymousSuccess

  • SASSuccess

  • NetworkError

  • AnonymousNetworkError

  • SASNetworkError

  • ClientOtherError

  • AnonymousClientOtherError

  • SASClientOtherError

  • ClientTimeoutError

  • AnonymousClientTimeoutError

  • SASClientTimeoutError

  • AuthorizationError

  • SASAuthorizationError

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.

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:

  • Success

  • AnonymousSuccess

  • SASSuccess

  • NetworkError

  • AnonymousNetworkError

  • SASNetworkError

  • ClientOtherError

  • AnonymousClientOtherError

  • SASClientOtherError

  • ServerOtherError

  • AnonymousServerOtherError

  • SASServerOtherError

  • ClientTimeoutError

  • AnonymousClientTimeoutError

  • SASClientTimeoutError

  • ServerTimeoutError

  • AnonymousServerTimeoutError

  • SASServerTimeoutError

  • AuthorizationError

  • SASAuthorizationError

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 Windows Azure Storage to read the request, send the response, and receive acknowledgment of the response.

19.333333

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.

11.4

PercentSuccess

double

The percentage of successful requests.

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 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.

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 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.

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 an SASClientTimeoutError. For more details about this status message, see Storage Analytics Logged Operations and Status Messages.

0

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.

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 an SASServerTimeoutError. For more details about this status message, see Storage Analytics Logged Operations and Status Messages.

0

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.

0

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.

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 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.

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 an SASServerOtherError. For more details about this status message, see Storage Analytics Logged Operations and Status Messages.

0

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.

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 an SASAuthorizationError. For more details about this status message, see Storage Analytics Logged Operations and Status Messages.

0

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.

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

Visa:
© 2014 Microsoft