This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 50%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAZ%3C/text%3E%3C/svg%3E)
Hey fellow azure fan boys.
I'm working on a project were we need to find exact retail prices on various azure products.
We are having some issues with finding prices on certain SQL products.
If i go to https://azure.microsoft.com/en-us/pricing/calculator add "Azure SQL Database"
Select "West Europe", "Single Database", "vCore", "General Purpose", "Provisioned", "Gen 5", "2 vCore"
I can find the same prices in retail API with this https://prices.azure.com/api/retail/prices?$filter=location eq 'EU West' and serviceName eq 'SQL Database' and skuName eq '2 vCore' and productName eq 'SQL Database Single General Purpose - Serverless - Compute Gen5'
If i change to "20 vCore" i should be able to find the same with this URL, but this returns 0 hit's
https://prices.azure.com/api/retail/prices?$filter=location eq 'EU West' and serviceName eq 'SQL Database' and skuName eq '20 vCore' and productName eq 'SQL Database Single General Purpose - Serverless - Compute Gen5'
If i get them all ( by removing the skuname ) these is nothing the would describe the one with 20 vCore. So this seem to only exist in the price calculator and azure portal, but not in the price list.
What am I missing here, how do i find the "SKU" for 20 vCore and calculate the price for this ?
sub question, we also seem to find SKU's that does not exist in the price calculator and portal, like the one with
48 vCore
https://prices.azure.com/api/retail/prices?$filter=location eq 'EU West' and serviceName eq 'SQL Database' and skuName eq '48 vCore' and productName eq 'SQL Database Single General Purpose - Serverless - Compute Gen5'
How can I tell from the returned response, this is not available
Quick note
I pulled all the data and added to a mongodb database, if i match on
{"location": "EU West", "serviceName": "SQL Database", "skuName": "2 vCore"} and group by productName i get 2 of each of these product's
SQL Database Single General Purpose - Serverless - Compute Gen5
SQL Database SingleDB Hyperscale - Compute DC-Series
SQL Database Single/Elastic Pool General Purpose - Compute Gen5
SQL Database Single General Purpose - Serverless - Compute DC-Series
SQL Database Single/Elastic Pool General Purpose - Compute DC-Series
SQL Database Single/Elastic Pool Business Critical - Compute Gen5
SQL Database Single/Elastic Pool Business Critical - Compute DC-Series
Where as if i match on {"location": "EU West", "serviceName": "SQL Database", "skuName": "20 vCore"} and group by productName i get 2 of each of these product's ... some are missing
SQL Database Single/Elastic Pool General Purpose - Compute Gen5
SQL Database Single/Elastic Pool General Purpose - Compute FSv2 Series
SQL Database Single/Elastic Pool Business Critical - Compute M Series
SQL Database Single/Elastic Pool Business Critical - Compute Gen5
Hello @Allan Zimmermannd Thank you for contacting us on Microsoft Q&A platform. Happy to assist!
I see that you are trying to pull retail prices on various azure products and noticed some issues with finding prices on certain SQL products.
It looks like a shared meter problem where 1 meter represents multiple SKUs.
SQL service has defined the pricing model in multiple patterns:
For serverless products, as the name suggests, the compute automatically scales up and down. Not sure why we have other SKUs for serverless, but I guess it is the min/max setting.
If you are looking for provisioned compute, the good example would be “SQL Database Single/Elastic Pool General Purpose - Compute Gen5”
There is one compute unit price for serverless in General Purpose and another unit price in Hyperscale each expressed in units of $/vcore-second. The max vcore setting (like say 20 vcores, 24 vcores, 32 vcores, 40 vcores, etc.) are all different serverless configurations, but doesn’t affect the unit price.
Hope this helps!
@Allan Zimmermannd Just checking in to see if you got a chance to see my response and if it helped, I would request you to "Accept Answer and Upvote" so that the relevancy of this post will improve when anyone in the community search for a similar query.
@Allan Zimmermannd We haven't heard back from you. Please reply if you have any questions in this matter and we will gladly continue the discussion.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 73%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
Hi Team,
I looked at the api response but I could not find the data associated with Standard_D2as_V5 SKU. Do I need adding certain query parameters to fetch the data of all available SKUs