'List available PricingTiers for Azure SQL Database Resource

Is there any way to read list of available Pricing Tiers (SKUs) for Azure SQL Database Resource?

The list of availabe SKUs (DTU and vCores) available here.

But I need to read this list using Azure REST API.

List of SKUs is available for some resources types like (VM, Storage, CognitiveService, etc.).

But this information is missing for Azure SQL Database.

Thanks for any help.

azureazure-sql-database


Solution 1:[1]

You can also use the following PowerShell commandlet after authenticating with Azure - Get-AzSqlServerServiceObjective -Location <LOCATION>

For example, Get-AzSqlServerServiceObjective -Location eastus

Reference - https://docs.microsoft.com/en-us/powershell/module/az.sql/get-azsqlserverserviceobjective?view=azps-4.2.0

Solution 2:[2]

I believe the API you're looking for is Capabilities - List By Location: https://docs.microsoft.com/en-us/rest/api/sql/capabilities/listbylocation.

I just tried the API for eastus location and it gave me all the information though in a bit convoluted way.

Solution 3:[3]

This is the current link to the docs:

https://docs.microsoft.com/en-us/rest/api/sql/2021-02-01-preview/capabilities/list-by-location

An example using the az rest command (substitute your {subscriptionId}):

az rest --method GET --url https://management.azure.com/subscriptions/{subscriptionId}/providers/Microsoft.Sql/locations/eastus/capabilities?api-version=2021-02-01-preview

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Pranav Jituri
Solution 2 Gaurav Mantri
Solution 3 John

Related Questions