question

SahebSeikh-5586 avatar image
0 Votes"
SahebSeikh-5586 asked Varsha-9437 commented

Azure Sql database price mismatch with portal and retail price api

Hello Azure Team,
Hope you are doing well!!

I need your help regarding price list information of SQL database, I need per hour price, storage data for DTU based database and Vcore based database(Through API), I am using retail price API-"https://prices.azure.com/api/retail/prices?$filter=serviceName eq 'SQL Database'&location='US East" for getting SQL database price information and I am getting correct price for DTU based databases all combinations listed below

-Basic
-Standard all combination(S0,S1,S2,S3,S4,S6,S7,S9,S12)
-Premium all combination(P1,P2,P4,P6,P11,P15)

When I try to search price information in API response for Vcore based databases (Genaral Purpose, Business critical and Hyperscale) then I am not able to get correct price information for each combination listed below

  • General Purpose
    GEN5----> Vcore - 2,4,6,8,10,12,14,16,18,20,24,32,40,80
    DC-Series----> Vcore -2,4,6,8
    Fsv2-Series--> Vcore -8,10,12,14,16,18,20,24,32,36,72

  • Business Critical
    GEN5---> Vcore - 2,4,6,8,10,12,14,16,18,20,24,32,40,80
    Fsv2-Series--> Vcore -8,10,12,14,16,18,20,24,32,64,128

  • Hyperscale
    GEN5----> Vcore - 2,4,6,8,10,12,14,16,18,20,24,32,40,80

Example- When I am searcing for "SQL Database Single/Elastic Pool General Purpose - Compute Gen5" '2 Vcore' combination of GEN5 series of General Purpose database then I am gettig UnitPrice 0.304434/hour but on portal it is $0.51/hour for "US East" region
Here is response for 2vcore-
{
"currencyCode"=>"USD",
"tierMinimumUnits"=>0.0,
"retailPrice"=>0.304434,
"unitPrice"=>0.304434,
"armRegionName"=>"eastus",
"location"=>"US East",
"effectiveStartDate"=>"2018-07-15T00:00:00Z",
"meterId"=>"d0fc12d4-91ca-4689-bf8f-9ccdf1b0a619",
"meterName"=>"vCore",
"productId"=>"DZH318Z0BPXL",
"skuId"=>"DZH318Z0BPXL/00BT",
"productName"=>"SQL Database Single/Elastic Pool General Purpose - Compute Gen5",
"skuName"=>"2 vCore",
"serviceName"=>"SQL Database",
"serviceId"=>"DZH3180HX10K",
"serviceFamily"=>"Databases",
"unitOfMeasure"=>"1 Hour",
"type"=>"Consumption",
"isPrimaryMeterRegion"=>false,
"armSkuName"=>"SQLDB_GP_Compute_Gen5_2"
}
I am verifying the cost from this link - https://azure.microsoft.com/en-in/pricing/details/azure-sql-database/single/

Please Let me know How can I get correct /hours price information of each type of database( Vcore) in selected region using this API or any other API

Note- I am using "US East" Region in API and I need SQL database price information to all available combinations in selected regions, I have listed above 'Us East' available database combination for each type of database.

azure-sql-databaseazure-cost-management
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

KalyanChanumolu-MSFT avatar image
0 Votes"
KalyanChanumolu-MSFT answered Varsha-9437 commented

@SahebSeikh-5586 Thank you for reaching out. We apologize for the delayed response.

If you are using an MSDN subscription or your subscription has an offer code applied, you may see a price that is different from the retail price.

Unfortunately, we will not be able to access your subscription from the Q&A forum.
Please reach out to Azure support so that an engineer can check your subscription details and help you accordingly.

You can create the support request as "Billing" issue

119377-image.png


If an answer is helpful, please "Accept answer" or "Up-Vote" which might help other community members reading this thread.


image.png (23.8 KiB)
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@KalyanChanumolu-MSFT thanks for your response. I am using API-"https://prices.azure.com/api/retail/prices?$filter=serviceName eq 'SQL Database'&location='US East" and this API not required any subscription.

Basically I need all the data for sql database by API which is available here - https://azure.microsoft.com/en-in/pricing/details/azure-sql-database/single/

0 Votes 0 ·

@SahebSeikh-5586 Thank you for clarifying.

Could you please let me know what is missing from the API response?
By default, the API returns only 100 entities, you will have to loop through all the pages using the NextPageLink property to get the complete result set.

0 Votes 0 ·

@KalyanChanumolu-MSFT Thanks for understanding my issue.

I have described my issue in example, API response showing unit-Price 0.304434/hours but pricing page https://azure.microsoft.com/en-in/pricing/details/azure-sql-database/single/ showing price 0.51/hours for same "2Vcor" combination of "SQL Database Single/Elastic Pool General Purpose - Compute Gen5" serious


Please have a look on this example part in my question

0 Votes 0 ·
Show more comments