Azure Advisor Overprovisioned Databases recommendation

asked 2021-11-02T05:57:55.71+00:00
Vikas Neekhra 6 Reputation points

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.

Azure SQL Database
Azure Cost Management
Azure Cost Management
An Azure service that provides cloud cost management capabilities.
967 questions
Azure Metrics Advisor
Azure Metrics Advisor
An Azure artificial intelligence analytics service that proactively monitors metrics and diagnoses issues.
66 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
437 questions
Azure Database for PostgreSQL
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. answered 2021-11-02T07:47:03.043+00:00
    KalyanChanumolu-MSFT 8,251 Reputation points Microsoft Employee

    @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 130616-image.png or upvote 130671-image.png which might help other community members reading this thread.