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
properties.databaseDtuMax
  • integer

The maximum DTU any one database can consume.

properties.databaseDtuMin
  • integer

The minimum DTU all databases are guaranteed.

properties.dtu
  • integer

The total shared DTU for the database elastic pool.

properties.edition

The edition of the elastic pool.

properties.storageMB
  • integer

Gets storage limit for the database elastic pool in MB.

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

tags
  • <string, string>

Resource tags.

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

Represents a database elastic pool.

ElasticPoolEdition

The edition of the elastic pool.

ElasticPoolState

The state of the elastic pool.

ElasticPoolUpdate

Represents an elastic pool update.

ElasticPool

Represents a database elastic pool.

Name Type Description
id
  • string

Resource ID.

kind
  • string

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

location
  • string

Resource location.

name
  • string

Resource name.

properties.creationDate
  • string

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

properties.databaseDtuMax
  • integer

The maximum DTU any one database can consume.

properties.databaseDtuMin
  • integer

The minimum DTU all databases are guaranteed.

properties.dtu
  • integer

The total shared DTU for the database elastic pool.

properties.edition

The edition of the elastic pool.

properties.state

The state of the elastic pool.

properties.storageMB
  • integer

Gets storage limit for the database elastic pool in MB.

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

tags
  • <string, string>

Resource tags.

type
  • string

Resource type.

ElasticPoolEdition

The edition of the elastic pool.

Name Type Description
Basic
  • string
Premium
  • string
Standard
  • string

ElasticPoolState

The state of the elastic pool.

Name Type Description
Creating
  • string
Disabled
  • string
Ready
  • string

ElasticPoolUpdate

Represents an elastic pool update.

Name Type Description
id
  • string

Resource ID.

name
  • string

Resource name.

properties.creationDate
  • string

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

properties.databaseDtuMax
  • integer

The maximum DTU any one database can consume.

properties.databaseDtuMin
  • integer

The minimum DTU all databases are guaranteed.

properties.dtu
  • integer

The total shared DTU for the database elastic pool.

properties.edition

The edition of the elastic pool.

properties.state

The state of the elastic pool.

properties.storageMB
  • integer

Gets storage limit for the database elastic pool in MB.

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

tags
  • <string, string>

Resource tags.

type
  • string

Resource type.