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

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

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

Returns recommended elastic pools.

## Path parameters

- `serverName` string, required

## Parameters

- `../../../common/v1/types.json#/components/parameters/ApiVersionParameter` — unresolved $ref
- `../../../common/v1/types.json#/components/parameters/SubscriptionIdParameter` — unresolved $ref
- `../../../common/v1/types.json#/components/parameters/ResourceGroupParameter` — unresolved $ref

## Response `200`

OK

- RecommendedElasticPoolListResult — Represents the response to a list recommended elastic pool request.
  - `value` RecommendedElasticPool[], required — The list of recommended elastic pools hosted in the server. — unresolved $ref

## Changes

- **2018-06-12** (2014-04-01) `cb220a8c7345` — 3 warning
  - deleted the `path` request parameter `resourceGroupName`
  - deleted the `path` request parameter `subscriptionId`
  - deleted the `query` request parameter `api-version`
- **2018-03-27** (2014-04-01) `2ae07c3ae84c` — 3 breaking
  - added the new path request parameter `resourceGroupName`
  - added the new path request parameter `subscriptionId`
  - added the new required `query` request parameter `api-version`

[Change history](https://skmtc.dev/azure/apis/azure-sql-database-7/changes/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers/:serverName/recommendedElasticPools/get.md)

---

[API](https://skmtc.dev/azure/apis/azure-sql-database-7.md) · [All operations](https://skmtc.dev/azure/apis/azure-sql-database-7/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/azure/azure-sql-database-7/revisions/cac26d4d9619/schema)