---
title: "GET /subscriptions/{subscriptionId}/providers/Microsoft.DBforMariaDB/locations/{locationName}/performanceTiers"
method: GET
path: "/subscriptions/{subscriptionId}/providers/Microsoft.DBforMariaDB/locations/{locationName}/performanceTiers"
tags: ["LocationBasedPerformanceTier"]
---

# GET /subscriptions/{subscriptionId}/providers/Microsoft.DBforMariaDB/locations/{locationName}/performanceTiers

`GET /subscriptions/{subscriptionId}/providers/Microsoft.DBforMariaDB/locations/{locationName}/performanceTiers`

List all the performance tiers at specified location in a given subscription.

## Path parameters

- `subscriptionId` string, required
- `locationName` string, required

## Query parameters

- `api-version` string, required

## Response `200`

OK

- PerformanceTierListResult — A list of performance tiers.
  - `value` PerformanceTierProperties[] — The list of performance tiers
    - `id` string — ID of the performance tier.
    - `maxBackupRetentionDays` integer — Maximum Backup retention in days for the performance tier edition
    - `minBackupRetentionDays` integer — Minimum Backup retention in days for the performance tier edition
    - `maxStorageMB` integer — Max storage allowed for a server.
    - `minLargeStorageMB` integer — Max storage allowed for a server.
    - `maxLargeStorageMB` integer — Max storage allowed for a server.
    - `minStorageMB` integer — Max storage allowed for a server.
    - `serviceLevelObjectives` PerformanceTierServiceLevelObjectives[] — Service level objectives associated with the performance tier
      - `id` string — ID for the service level objective.
      - `edition` string — Edition of the performance tier.
      - `vCore` integer — vCore associated with the service level objective
      - `hardwareGeneration` string — Hardware generation associated with the service level objective
      - `maxBackupRetentionDays` integer — Maximum Backup retention in days for the performance tier edition
      - `minBackupRetentionDays` integer — Minimum Backup retention in days for the performance tier edition
      - `maxStorageMB` integer — Max storage allowed for a server.
      - `minStorageMB` integer — Max storage allowed for a server.

---

[API](https://skmtc.net/azure/apis/mariadbmanagementclient.md) · [All operations](https://skmtc.net/azure/apis/mariadbmanagementclient/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/azure/mariadbmanagementclient/versions/38f5e81b0403/schema)