Elastic Pool Database Activities - List By Elastic Pool

Returns activity on databases inside of an elastic pool.

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

URI Parameters

Name In Required Type Description
elasticPoolName
path True

string

The name of the elastic pool.

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

ElasticPoolDatabaseActivityListResult

OK

Examples

List elastic pool database activity

Sample request

GET https://management.azure.com/subscriptions/9d4e2ad0-e20b-4464-9219-353bded52513/resourceGroups/sqlcrudtest-4673/providers/Microsoft.Sql/servers/sqlcrudtest-603/elasticPools/7537/elasticPoolDatabaseActivity?api-version=2014-04-01

Sample response

{
  "value": [
    {
      "id": "/subscriptions/9d4e2ad0-e20b-4464-9219-353bded52513/resourceGroups/sqlcrudtest-4673/providers/Microsoft.Sql/servers/sqlcrudtest-603/elasticPools/7537/elasticPoolDatabaseActivity/3a3272b3-f1fe-423c-9feb-7b843157eda5",
      "name": "3a3272b3-f1fe-423c-9feb-7b843157eda5",
      "type": "Microsoft.Sql/servers/elasticPools/elasticPoolDatabaseActivity",
      "location": "Japan East",
      "properties": {
        "operationId": "3a3272b3-f1fe-423c-9feb-7b843157eda5",
        "serverName": "sqlcrudtest-603",
        "databaseName": "2396",
        "state": "COMPLETED",
        "operation": "UPDATE",
        "errorCode": null,
        "errorMessage": null,
        "errorSeverity": null,
        "startTime": "2016-10-23T03:07:12.57Z",
        "endTime": "2016-10-23T03:08:02.95Z",
        "percentComplete": 100,
        "currentServiceObjective": "ElasticPool",
        "requestedServiceObjective": null,
        "currentElasticPoolName": "7537",
        "requestedElasticPoolName": null
      }
    },
    {
      "id": "/subscriptions/9d4e2ad0-e20b-4464-9219-353bded52513/resourceGroups/sqlcrudtest-4673/providers/Microsoft.Sql/servers/sqlcrudtest-603/elasticPools/7537/elasticPoolDatabaseActivity/95108a78-384e-48d3-b4de-7bf23b93a26d",
      "name": "95108a78-384e-48d3-b4de-7bf23b93a26d",
      "type": "Microsoft.Sql/servers/elasticPools/elasticPoolDatabaseActivity",
      "location": "Japan East",
      "properties": {
        "operationId": "95108a78-384e-48d3-b4de-7bf23b93a26d",
        "serverName": "sqlcrudtest-603",
        "databaseName": "2396",
        "state": "COMPLETED",
        "operation": "CREATE",
        "errorCode": null,
        "errorMessage": null,
        "errorSeverity": null,
        "startTime": "2016-10-23T03:06:11.19Z",
        "endTime": "2016-10-23T03:06:49.19Z",
        "percentComplete": 100,
        "currentServiceObjective": "ElasticPool",
        "requestedServiceObjective": null,
        "currentElasticPoolName": "7537",
        "requestedElasticPoolName": null
      }
    }
  ]
}

Definitions

Name Description
ElasticPoolDatabaseActivity

Represents the activity on an elastic pool.

ElasticPoolDatabaseActivityListResult

Represents the response to a list elastic pool database activity request.

ElasticPoolDatabaseActivity

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

string

The name of the current elastic pool the database is in if available.

properties.currentServiceObjective

string

The name of the current service objective if available.

properties.databaseName

string

The database name.

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

string

The name for the elastic pool the database is moving into if available.

properties.requestedServiceObjective

string

The name of the requested service objective if available.

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.

ElasticPoolDatabaseActivityListResult

Represents the response to a list elastic pool database activity request.

Name Type Description
value

ElasticPoolDatabaseActivity[]

The list of elastic pool database activities.