question

VikasNeekhra-5125 avatar image
0 Votes"
VikasNeekhra-5125 asked VikasNeekhra-5125 edited

Azure Advisor Overprovisioned Databases recommendation

I am trying to find Azure Overprovisioned databases as mentioned in this url: https://docs.microsoft.com/en-us/azure/advisor/advisor-cost-recommendations
It seems Azure Advisor will generate recommendations for "MariaDB, MySQL, and PostgreSQL servers by right-sizing".

So I am looking for a sample response from Azure Advisor Resource Graph API for this, as in my current infrastructure I am not able to find any underutilized Databases for right-sizing.

azure-sql-databaseazure-cost-managementazure-database-postgresqlazure-database-mysqlazure-metrics-advisor
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
1 Vote"
KalyanChanumolu-MSFT answered VikasNeekhra-5125 commented

@VikasNeekhra-5125 Welcome to Microsoft Q&A forums.

You may not have any databases that are underutilized at this time.

Here is a sample response for a right-sizing recommendation for Azure SQL Database.
The response is same for other databases as well.

 {
   "value": [
     {
       "properties": {
         "category": "Cost",
         "impact": "Medium",
         "impactedField": "Microsoft.Sql/servers/databases",
         "impactedValue": "PICDB",
         "lastUpdated": "2021-11-02T03:47:47.6633673Z",
         "recommendationTypeId": "b83241d3-47ba-4603-8d5a-a1b3331e74f4",
         "shortDescription": {
           "problem": "Right-size underutilized SQL Databases",
           "solution": "Right-size underutilized SQL Databases"
         },
         "extendedProperties": {
           "ServerName": "XXXXXXX-dataserver-dev",
           "DatabaseName": "PICDB",
           "IsInReplication": "0",
           "ResourceGroup": "CXP-XXXXXXX",
           "DatabaseSize": "794",
           "Region": "East US",
           "ObservationPeriodStartDate": "2021-10-17T00:00:00.0000000Z",
           "ObservationPeriodEndDate": "2021-11-01T00:00:00.0000000Z",
           "Recommended_DTU": "10",
           "Recommended_SKU": "S0",
           "HasRecommendation": "true",
           "savingsAmount": "3.6270000000000004",
           "annualSavingsAmount": "43.524",
           "savingsCurrency": "USD"
         },
         "resourceMetadata": {
           "resourceId": "/subscriptions/XXXXXXX-XXXXXXX-XXXXXXX/resourceGroups/CXP-XXXXXXX/providers/Microsoft.Sql/servers/XXXXXXX-dataserver-dev/databases/PICDB"
         }
       },
       "id": "/subscriptions/XXXXXXX-XXXXXXX-XXXXXXX/resourceGroups/CXP-XXXXXXX/providers/Microsoft.Sql/servers/XXXXXXX-dataserver-dev/databases/PICDB/providers/Microsoft.Advisor/recommendations/321e749b-d8ef-8328-9cf5-bcbd7425d44c",
       "type": "Microsoft.Advisor/recommendations",
       "name": "321e749b-d8ef-8328-9cf5-bcbd7425d44c"
     }
   ]
 }

I hope this helps.
Please let us know if you have any further questions.


If an answer is helpful, please click on 130616-image.png or upvote 130671-image.png which might help other community members reading this thread.

· 2
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.

above response seems to be Advisor REST api response, could you please share the Advisor Resource Graph response.

`AdvisorResources
| where type == 'microsoft.advisor/recommendations'
| where properties.category == 'Cost' | where properties.shortDescription.problem == 'Right-size underutilized SQL Databases'

0 Votes 0 ·

@KalyanChanumolu-MSFT

Could you please check below query?

Do we need to do any settings/configuration in our current DB, so that Advisor can start generating recommendations for "Right-size underutilized SQL Databases"?

Also what is the criteria to get this type of recommendations?

And as per the documentation, Advisor should recommend for MariaDB, MySQL, and PostgreSQL servers but you have sent the response for Microsoft.Sql server, so which all DBs will be covered by Advisor for Cost category under "Right-size underutilized SQL Databases"

Could you also please check this question related to advisor only?
https://docs.microsoft.com/en-us/answers/questions/612218/azure-advisor-resource-graph-api.html

0 Votes 0 ·