---
title: "GET /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/elasticPools"
method: GET
path: "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/elasticPools"
tags: ["ElasticPools"]
---

# GET /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/elasticPools

`GET /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/elasticPools`

Gets all elastic pools in a server.

## Path parameters

- `resourceGroupName` string, required
- `serverName` string, required
- `subscriptionId` string, required

## Query parameters

- `$skip` integer
- `api-version` string, required

## Response `200`

Succeeded

- ElasticPoolListResult — The result of an elastic pool list request.
  - `value` ElasticPool[] — Array of results. — unresolved $ref
  - `nextLink` string — Link to retrieve next page of results.

## Other responses

- `default` — *** Error Responses: *** * 400 ElasticPoolStorageBelowLimitMB - Attempting to set the elastic pool storage limit below the supported limit. * 400 ProvisioningDisabled - Displays error message from resources operation authorizer as is, without changes * 400 ElasticPoolStorageNotAllowedMB - Attempting to set the elastic pool storage limit in mb which doesn't match the allowed values. * 400 ElasticPoolStorageAboveLimitMB - Attempting to set the elastic pool storage limit below the supported limit. * 400 ElasticPoolUpdateHkNotAllowed - The elastic pool cannot lower its service tier from Premium to Standard or Basic since one or more of its databases use memory-optimized objects. * 400 ElasticPoolOverFileSpace - Insufficient file space in the elastic pool. * 400 InvalidTier - The user specified an invalid tier. * 400 ServerQuotaExceeded - Server cannot be added to a subscription because it will exceed quota. * 400 ElasticPoolAlreadyExists - The server already contains an elastic pool with the specified name. * 400 InvalidInputValueForEdition - Specified edition is not supported for elastic pool provisioning. * 400 ElasticPoolDtuBelowLimit - The requested DTU value is too low for the requested elastic pool service tier. * 400 ElasticPoolDtuAboveLimit - The requested DTU value is too high for the requested elastic pool service tier. * 400 ElasticPoolDbDtuMaxBelowLimit - The requested per database DTU max is too low for the requested elastic pool service tier. * 400 ElasticPoolDbDtuMaxAboveLimit - The requested per database DTU max is too high for the requested elastic pool service tier. * 400 InvalidInputValueForDatabaseDtuMax - Attempting to set the DTU max per database for the Resource Pool which doesn't match the allowed values. * 400 ElasticPoolDbDtuMinAboveLimit - The requested DTU min per database is too high for the requested service tier. * 400 InvalidInputValueForDatabaseDtuMin - Attempting to set the DTU min per database for the Resource Pool which doesn't match the allowed values. * 400 ElasticPoolStorageAboveLimitGB - Attempting to set the elastic pool storage limit below the supported limit. * 400 ElasticPoolOverStorageUsage - Attempting to write data to a database when the storage limit of the elastic pool has been reached. * 400 ElasticPoolsNotEnabled - Elastic pools have not been enabled in this region. * 400 ElasticPoolNotEmpty - Request to delete an elastic pool that is not empty. * 400 ElasticPoolStorageBelowLimitGB - Attempting to set the elastic pool storage limit below the supported limit. * 400 ElasticPoolStorageNotAllowedGB - Attempting to set the elastic pool storage limit in gb which doesn't match the allowed values. * 400 ElasticPoolDatabaseLimit - The elastic pool has reached its limit for number of databases. * 400 ElasticPoolStorageDecreasePrecondition - There was an attempt to decrease the storage limit of the elastic pool below its storage usage. * 400 ElasticPoolBusy - A management operation was attempted on an elastic pool which is busy. * 400 InvalidInputValueDatabaseDtuMinLargerThanMax - Attempting to set the DTU min per database higher than the DTU max per database. * 404 SubscriptionDoesNotHaveServer - The requested server was not found * 404 ElasticPoolNotFound - The specified elastic pool does not exist for the specified server. * 404 OperationIdNotFound - The operation with Id does not exist. * 405 NotSupported - This functionality is not supported. * 409 ServerDisabled - Server is disabled. * 409 OperationCancelled - The operation has been cancelled by user. * 409 OperationInterrupted - The operation on the resource could not be completed because it was interrupted by another operation on the same resource. * 500 OperationTimedOut - The operation timed out and automatically rolled back. Please retry the operation. * 503 ServiceTemporarilyUnavailable - Feature temporarily unavailable.

---

[API](https://skmtc.dev/azure/apis/sqlmanagementclient-33.md) · [All operations](https://skmtc.dev/azure/apis/sqlmanagementclient-33/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/azure/sqlmanagementclient-33/revisions/79e4e0ded5a4/schema)