---
title: "GET /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/instancePools"
method: GET
path: "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/instancePools"
tags: ["InstancePools"]
---

# GET /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/instancePools

`GET /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/instancePools`

Gets a list of instance pools in the resource group

## Path parameters

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

## Query parameters

- `api-version` string, required

## Response `200`

Successfully retrieved the list of instance pools.

- InstancePoolListResult — A list of Azure SQL instance pools.
  - `value` InstancePool[] — Array of results. — unresolved $ref
  - `nextLink` string — Link to retrieve next page of results.

## Other responses

- `default` — *** Error Responses: ***

---

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