Elastic Pools - Update

Updates an existing elastic pool.

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

URI Parameters

Name In Required Type Description
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 to be updated.

api-version
query True
  • string

The API version to use for the request.

Request Body

Name Required Type Description
databaseDtuMax
  • integer
    int32

The maximum DTU any one database can consume.

databaseDtuMin
  • integer
    int32

The minimum DTU all databases are guaranteed.

dtu
  • integer
    int32

The total shared DTU for the database elastic pool.

edition

The edition of the elastic pool.

storageMB
  • integer
    int32

Gets storage limit for the database elastic pool in MB.

tags
  • <string, string>

Resource tags.

zoneRedundant
  • boolean

Whether or not this database elastic pool is zone redundant, which means the replicas of this database will be spread across multiple availability zones.

Responses

Name Type Description
200 OK

OK

202 Accepted

Accepted

Examples

Update elastic pool max
Update elastic pool min

Update elastic pool max

Sample Request

PATCH https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/servers/sqlcrudtest-8069/elasticPools/sqlcrudtest-8102?api-version=2014-04-01
{
  "properties": {
    "creationDate": "2017-02-10T01:25:25.033Z",
    "edition": "Basic",
    "state": "Ready",
    "dtu": 50,
    "databaseDtuMin": 0,
    "databaseDtuMax": 5,
    "storageMB": 5000
  }
}

Sample Response

{
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/servers/sqlcrudtest-8069/elasticPools/sqlcrudtest-8102",
  "name": "sqlcrudtest-8102",
  "type": "Microsoft.Sql/servers/elasticPools",
  "location": "Japan East",
  "kind": null,
  "properties": {
    "creationDate": "2017-02-10T01:25:25.033Z",
    "edition": "Basic",
    "state": "Ready",
    "dtu": 50,
    "databaseDtuMin": 0,
    "databaseDtuMax": 5,
    "storageMB": 5000
  }
}

Update elastic pool min

Sample Request

PATCH https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/servers/sqlcrudtest-8069/elasticPools/sqlcrudtest-8102?api-version=2014-04-01
{}

Sample Response

{
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-2369/providers/Microsoft.Sql/servers/sqlcrudtest-8069/elasticPools/sqlcrudtest-8102",
  "name": "sqlcrudtest-8102",
  "type": "Microsoft.Sql/servers/elasticPools",
  "location": "Japan East",
  "kind": null,
  "properties": {
    "creationDate": "2017-02-10T01:25:25.033Z",
    "edition": "Basic",
    "state": "Ready",
    "dtu": 50,
    "databaseDtuMin": 0,
    "databaseDtuMax": 5,
    "storageMB": 5000
  }
}

Definitions

ElasticPool
ElasticPoolEdition

The edition of the elastic pool.

ElasticPoolState

The state of the elastic pool.

Name Type Description
creationDate
  • string
    date-time

The creation date of the elastic pool (ISO8601 format).

databaseDtuMax
  • integer
    int32

The maximum DTU any one database can consume.

databaseDtuMin
  • integer
    int32

The minimum DTU all databases are guaranteed.

dtu
  • integer
    int32

The total shared DTU for the database elastic pool.

edition

The edition of the elastic pool.

kind
  • string

Kind of elastic pool. This is metadata used for the Azure portal experience.

location
  • string

Resource location.

state

The state of the elastic pool.

storageMB
  • integer
    int32

Gets storage limit for the database elastic pool in MB.

tags
  • <string, string>

Resource tags.

zoneRedundant
  • boolean

Whether or not this database elastic pool is zone redundant, which means the replicas of this database will be spread across multiple availability zones.

The edition of the elastic pool.

Name Description
Basic
Premium
Standard

The state of the elastic pool.

Name Description
Creating
Disabled
Ready