Elastic Pool Activities - List By Elastic Pool

Returns elastic pool activities.

GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/elasticPools/{elasticPoolName}/elasticPoolActivity?api-version=2014-04-01

URI Parameters

Name In Required Type Description
elasticPoolName
path True

string

The name of the elastic pool for which to get the current activity.

resourceGroupName
path True

string

The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

serverName
path True

string

The name of the server.

subscriptionId
path True

string

The subscription ID that identifies an Azure subscription.

api-version
query True

string

The API version to use for the request.

Responses

Name Type Description
200 OK

ElasticPoolActivityListResult

OK

Examples

List Elastic pool activity

Sample request

GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-4291/providers/Microsoft.Sql/servers/sqlcrudtest-6574/elasticPools/8749/elasticPoolActivity?api-version=2014-04-01

Sample response

{
  "value": [
    {
      "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-4291/providers/Microsoft.Sql/servers/sqlcrudtest-6574/elasticPools/8749/elasticPoolActivity/851f1672-f7f0-46f6-a262-ee9b51e18e97",
      "name": "851f1672-f7f0-46f6-a262-ee9b51e18e97",
      "type": "Microsoft.Sql/servers/elasticPools/elasticPoolActivity",
      "location": "Japan East",
      "properties": {
        "operationId": "851f1672-f7f0-46f6-a262-ee9b51e18e97",
        "serverName": "sqlcrudtest-6574",
        "elasticPoolName": "8749",
        "state": "COMPLETED",
        "operation": "CREATE",
        "errorCode": null,
        "errorMessage": null,
        "errorSeverity": null,
        "startTime": "2017-02-10T02:03:06.16Z",
        "endTime": "2017-02-10T02:03:23.263Z",
        "percentComplete": 100,
        "requestedElasticPoolName": null,
        "requestedDtuGuarantee": 100,
        "requestedDatabaseDtuCap": 5,
        "requestedDatabaseDtuGuarantee": 0,
        "requestedStorageLimitInGB": 9,
        "requestedStorageLimitInMB": 10000
      }
    }
  ]
}

Definitions

Name Description
ElasticPoolActivity

Represents the activity on an elastic pool.

ElasticPoolActivityListResult

Represents the response to a list elastic pool activity request.

ElasticPoolActivity

Represents the activity on an elastic pool.

Name Type Description
id

string

Resource ID.

location

string

The geo-location where the resource lives

name

string

Resource name.

properties.elasticPoolName

string

The name of the elastic pool.

properties.endTime

string

The time the operation finished (ISO8601 format).

properties.errorCode

integer

The error code if available.

properties.errorMessage

string

The error message if available.

properties.errorSeverity

integer

The error severity if available.

properties.operation

string

The operation name.

properties.operationId

string

The unique operation ID.

properties.percentComplete

integer

The percentage complete if available.

properties.requestedDatabaseDtuCap

integer

The requested per database DTU cap.

properties.requestedDatabaseDtuGuarantee

integer

The requested per database DTU guarantee.

properties.requestedDatabaseDtuMax

integer

The requested max DTU per database if available.

properties.requestedDatabaseDtuMin

integer

The requested min DTU per database if available.

properties.requestedDtu

integer

The requested DTU for the pool if available.

properties.requestedDtuGuarantee

integer

The requested DTU guarantee.

properties.requestedElasticPoolName

string

The requested name for the elastic pool if available.

properties.requestedStorageLimitInGB

integer

The requested storage limit for the pool in GB if available.

properties.requestedStorageLimitInMB

integer

The requested storage limit in MB.

properties.serverName

string

The name of the server the elastic pool is in.

properties.startTime

string

The time the operation started (ISO8601 format).

properties.state

string

The current state of the operation.

type

string

Resource type.

ElasticPoolActivityListResult

Represents the response to a list elastic pool activity request.

Name Type Description
value

ElasticPoolActivity[]

The list of elastic pool activities.