Azure API Management
An Azure service that provides a hybrid, multi-cloud management platform for APIs.
1,960 questions
Please refer to the following REST APIs available:
Azure Metrics API to find the purchase model (vCore or DTU)
![](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(73.60000000000001, 15%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPA%3C/text%3E%3C/svg%3E)
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: Most helpful
-
Alberto Morillo 33,426 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. -
Alberto Morillo 33,426 Reputation points MVP
2021-11-30T14:56:08.377+00:00 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.
-
GeethaThatipatri-MSFT 29,017 Reputation points Microsoft Employee2021-12-06T22:43:45.12+00:00 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 -
GeethaThatipatri-MSFT 29,017 Reputation points Microsoft Employee
2021-12-08T19:05:27.883+00:00 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 -
GeethaThatipatri-MSFT 29,017 Reputation points Microsoft Employee
2021-12-09T22:01:59.903+00:00 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 -
Padmini Anand 21 Reputation points
2021-12-10T04:02:37.823+00:00 @ GeethaThatipatri-MSFT Thanks for the details.
-
GeethaThatipatri-MSFT 29,017 Reputation points Microsoft Employee
2021-12-10T16:08:43.917+00:00 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 -