azureazure-sql-database

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.

Solution

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

    For example, Get-AzSqlServerServiceObjective -Location eastus

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