Get Table Service Stats

Article
06/27/2023

The Get Table Service Stats operation retrieves statistics that are related to replication for Azure Table Storage. It's available only on the secondary location endpoint when read-access geo-redundant replication is enabled for the storage account.

Request

The Get Table Service Stats request may be constructed as follows. We recommend that you use HTTPS. Replace myaccount with the name of your storage account, and note that the -secondary suffix is required:

Method	Request URI	HTTP version
GET	`https://myaccount-secondary.table.core.windows.net/?restype=service&comp=stats`	HTTP/1.1

Note

The URI must always include a slash character (/) to separate the hostname from the path and query portions of the URI. In this operation, the path portion of the URI is empty.

URI parameters

The following additional parameters may be specified on the request URI:

Parameter	Description
`Timeout`	Optional. The `timeout` parameter is expressed in seconds.

Request headers

The required and optional request headers are described in the following table:

Request header	Description
`Authorization`	Required. Specifies the authorization scheme, account name, and signature. For more information, see Authorize requests to Azure Storage.
`Date or x-ms-date`	Required. Specifies the Coordinated Universal Time (UTC) for the request. For more information, see Authorize requests to Azure Storage.
`x-ms-version`	Required for all authorized requests. Specifies the version of the operation to use for this request. For more information, see Versioning for the Azure Storage services.
`x-ms-client-request-id`	Optional. Provides a client-generated, opaque value with a 1-kibibyte (KiB) character limit that's recorded in the logs when logging is configured. We highly recommend that you use this header to correlate client-side activities with requests that the server receives. For more information, see [Monitor Azure Table Storage.

Request body

None.

Response

The response includes an HTTP status code, a set of response headers, and a response body

Status code

A successful operation returns status code 200 (OK). When it's called on a secondary location endpoint that's not enabled for a secondary read, it returns HTTP status code 403 (Insufficient Account Permissions).

Response headers

The response for this operation includes the following headers. The response also includes additional standard HTTP headers. All standard headers conform to the HTTP/1.1 protocol specification.

Response header	Description
`x-ms-request-id`	Uniquely identifies the request that was made and can be used to troubleshoot the request. For more information, see Troubleshoot API operations.
`x-ms-version`	Specifies the version of the operation that was used for the response. For more information, see Versioning for the Azure Storage services.
`Date`	A UTC date/time value that's generated by the service, which indicates the time when the response was initiated.
`x-ms-client-request-id`	Can be used to troubleshoot requests and their corresponding responses. The value of this header is equal to the value of the `x-ms-client-request-id` header if it's present in the request and the value contains no more than 1,024 visible ASCII characters. If the `x-ms-client-request-id` header isn't present in the request, it won't be present in the response.

Response body

The format of the response body is as follows:

<?xml version="1.0" encoding="utf-8"?>  
<StorageServiceStats>  
  <GeoReplication>        
      <Status>live|bootstrap|unavailable</Status>  
      <LastSyncTime>sync-time|<empty></LastSyncTime>  
  </GeoReplication>  
</StorageServiceStats>

The elements of the response body are described in the following table:

Response header Description

Status The status of the secondary location. Possible values are:

- live: Indicates that the secondary location is active and operational.
- bootstrap: Indicates that the initial synchronization from the primary location to the secondary location is in progress. This ordinarily occurs when replication is first enabled.
- unavailable: Indicates that the secondary location is temporarily unavailable.

LastSyncTime A UTC date/time value, to the second. All primary writes that precede this value are guaranteed to be available for read operations at the secondary write. Primary writes after this point in time might or might not be available for reads.

The value might be empty if LastSyncTime is unavailable. This can happen if the replication status is bootstrap or unavailable.

Although geo-replication is continuously enabled, the LastSyncTime result might reflect a cached value from the service that's refreshed every few minutes.

Response header	Description
`Status`	The status of the secondary location. Possible values are: - live: Indicates that the secondary location is active and operational. - bootstrap: Indicates that the initial synchronization from the primary location to the secondary location is in progress. This ordinarily occurs when replication is first enabled. - unavailable: Indicates that the secondary location is temporarily unavailable.
`LastSyncTime`	A UTC date/time value, to the second. All primary writes that precede this value are guaranteed to be available for read operations at the secondary write. Primary writes after this point in time might or might not be available for reads. The value might be empty if `LastSyncTime` is unavailable. This can happen if the replication status is bootstrap or unavailable. Although geo-replication is continuously enabled, the `LastSyncTime` result might reflect a cached value from the service that's refreshed every few minutes.

Authorization

Only the account owner may call this operation.

Remarks

With geo-redundant replication, Azure Storage maintains your data durably in two locations. In both locations, Azure Storage constantly maintains multiple healthy replicas of the data.

The location where you read, create, update, or delete data is the primary storage account location. The primary location exists in the region you choose when you create an account via the Azure Management Azure classic portal (for example, North Central US).

The location to which your data is replicated is the secondary location. The secondary location resides in a region that's automatically geographically paired with the primary region. Read-only access is available from the secondary location, if read-access geo-redundant replication is enabled for your storage account.

For more information about read-access geo-redundant replication, see Data redundancy.

To construct a request for a read operation against the secondary endpoint, append -secondary to the account name in the URI that you use to read from Table Storage. For example, a secondary URI for the Query Entities operation will be similar to https://myaccount-secondary.table.core.windows.net/mytable(PartitionKey='<partition-key>',RowKey='<row-key>').

Sample request and response

The following is a sample request for the Get Table Service Stats operation:

GET http://myaccount-secondary.table.core.windows.net/?restype=service&comp=stats HTTP/1.1

The request is sent with the following headers:

x-ms-version: 2013-08-15  
x-ms-date: Wed, 23 Oct 2013 22:08:44 GMT  
Authorization: SharedKey myaccount:CY1OP3O3jGFpYFbTCBimLn0Xov0vt0khH/E5Gy0fXvg=

The status code and response headers are returned as follows:

HTTP/1.1 200 OK  
Content-Type: application/xml  
Date: Wed, 23 Oct 2013 22:08:54 GMT  
x-ms-version: 2013-08-15  
x-ms-request-id: cb939a31-0cc6-49bb-9fe5-3327691f2a30  
Server: Windows-Azure-Table/1.0 Microsoft-HTTPAPI/2.0

The response includes the following XML body:

<?xml version="1.0" encoding="utf-8"?>  
<StorageServiceStats>  
  <GeoReplication>  
      <Status>live</Status>  
      <LastSyncTime> Wed, 23 Oct 2013 22:05:54 GMT</LastSyncTime>        
  </GeoReplication>  
</StorageServiceStats>

Share via