Elastic Pool Database Activities

Service:
SQL Database
API Version:
2014-04-01

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={api-version}
With optional parameters: 
GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/elasticPools/{elasticPoolName}/elasticPoolDatabaseActivity?$expand={$expand}&api-version={api-version}

URI Parameters

Name In Required Type Description
transparentDataEncryptionName
 path True
  • string
The name of the transparent data encryption configuration.
subscriptionId
 path True
  • string

The subscription ID that identifies an Azure subscription.
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.
elasticPoolName
 path True
  • string

The name of the elastic pool.
$expand
 query
  • string
A comma separated list of child objects to expand in the response. Possible properties: serviceTierAdvisors, transparentDataEncryption.
api-version
 query True
  • string

The API version to use for the request.

Responses

Name Type Description
200 OK

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

Status code:
200 
{
  "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.577Z",
        "endTime": "2016-10-23T03:08:02.950Z",
        "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.190Z",
        "endTime": "2016-10-23T03:06:49.197Z",
        "percentComplete": 100,
        "currentServiceObjective": "ElasticPool",
        "requestedServiceObjective": null,
        "currentElasticPoolName": "7537",
        "requestedElasticPoolName": null
      }
    }
  ]
}

Definitions

ElasticPoolDatabaseActivity

Represents the activity on an elastic pool.
ElasticPoolDatabaseActivityListResult

Represents the activity on an elastic pool.

Name Type Description
currentElasticPoolName
  • string

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

The name of the current service objective if available.
databaseName
  • string

The database name.
endTime
  • string
    date-time

The time the operation finished (ISO8601 format).
errorCode
  • integer
    int32

The error code if available.
errorMessage
  • string

The error message if available.
errorSeverity
  • integer
    int32

The error severity if available.
location
  • string

The geo-location where the resource lives
operation
  • string

The operation name.
operationId
  • string
    uuid

The unique operation ID.
percentComplete
  • integer
    int32

The percentage complete if available.
requestedElasticPoolName
  • string

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

The name of the requested service objective if available.
serverName
  • string

The name of the server the elastic pool is in.
startTime
  • string
    date-time

The time the operation started (ISO8601 format).
state
  • string

The current state of the operation.
Name Type Description
value

The list of elastic pool database activities.