List available PricingTiers for Azure SQL Database Resource

2
votes

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.

2
azureazure-sql-database

2 Answers

1
votes

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.

1
votes

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