Azure API Management
An Azure service that provides a hybrid, multi-cloud management platform for APIs.
1,158 questions
Please refer to the following REST APIs available:
Azure Metrics API to find the purchase model (vCore or DTU)
Padmini Anand
21
Reputation points
I am looking for Azure Metric API to identify SQL Database's purchase model. Is there any azure API to find the SQL database is either vCore or DTU ?
1 answer
Sort by: Newest
-
Alberto Morillo 26,131 Reputation points MVP2021-11-29T13:57:36.53+00:00 -
Padmini Anand 21 Reputation points
2021-11-30T11:38:05.63+00:00 @Alberto Morillo
Can you share all the possible values of "kind" (kind of database) for DTU and vCore from response of Databases - GetThe following are the possible value I could find, "v12.0,user (DTU), "v12.0,system" (DTU), "v12.0,user,vcore" (vCore).
Let me know the details as I need this value to set the metrics based upon the type of the database model.
-
I cannot say for sure all the possible values as changes are progressively staged by SQL Azure teams without any advice even months they are publicly shared.
Hi, @Padmini Anand use the current SKU.tier to tell whether it is a VCore or DTU database (you would have to do a mapping from the tiers like Standard / Premium / GeneralPurpose / BusinessCritical / Hyperscale, but at least some of that is publicly documented here which you can refer.
Regards
Geetha
Hi, @Padmini Anand id you had the chance to check the above doc.? Please let us know if you need any additional information.
Regards
Geetha
Hi, @Padmini Anand id you had the chance to check the above comments, Please let us know if you need any additional information.
Regards
Geetha
@ GeethaThatipatri-MSFT Thanks for the details.
Hi, @Padmini Anand Thank you for visiting Microsoft QA forums! please click on accept answer This will help other community members facing similar queries to refer to this solution.
Regards
Geetha
Sign in to comment