Azure SQL Database
An Azure relational database service.
3,320 questions
Please refer to the following REST APIs available:
Azure Metrics API to find the purchase model (vCore or DTU)
Padmini Anand
1
Reputation point
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 24,801 Reputation points Microsoft MVP2021-11-29T13:57:36.53+00:00 -
Padmini Anand 1 Reputation point
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 24,801 Reputation points Microsoft 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 15,106 Reputation points Microsoft Employee
2021-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 15,106 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 15,106 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 1 Reputation point
2021-12-10T04:02:37.823+00:00 @ GeethaThatipatri-MSFT Thanks for the details.
-
GeethaThatipatri-MSFT 15,106 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 -