Azure Advisor Overprovisioned Databases recommendation

Question

I am trying to find Azure Overprovisioned databases as mentioned in this url: https://learn.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.

Answer

@Vikas Neekhra 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 or upvote which might help other community members reading this thread.

Azure Advisor Overprovisioned Databases recommendation

1 answer