O recomendador de instâncias subprovisionadas ajuda a detectar instâncias com alta utilização de CPU e/ou memória.
Depois, são exibidas recomendações para otimizar a instância.
Nesta página, descrevemos como esse recomendador funciona e como usá-lo.
Como funciona
Quando uma alta utilização de CPU e/ou memória for detectada, será exibida uma recomendação para aumentar o tamanho da sua instância e reduzir o uso de CPU e/ou memória no pico.
GET https://recommender.googleapis.com/v1beta1/projects/PROJECT-ID/locations/LOCATION/recommenders/google.cloudsql.instance.UnderprovisionedRecommender/recommendations
Substitua:
PROJECT_ID: o ID do projeto
LOCATION: uma região, como us-central1.
Se o recomendador detectar instâncias subprovisionadas, ele as listará em uma
tabela. Cada linha mostra o nome da instância, uma breve recomendação, o tipo de máquina atual,
o tipo de máquina recomendado, o local e a data da última atualização.
Ver insights e recomendações detalhadas
Console
Para receber insights e recomendações detalhadas sobre uma instância subprovisionada usando o
consoleGoogle Cloud , clique no botão de recomendação na lista de instâncias.
gcloud
Para receber insights e recomendações detalhadas sobre instâncias subprovisionadas usando gcloud, execute o comando
gcloud recommender insights list da seguinte maneira:
gcloud recommender insights list \
--project=PROJECT_ID \
--location=LOCATION \
--insight-type=google.cloudsql.instance.INSIGHT_TYPE
Substitua:
PROJECT_ID: o ID do projeto
LOCATION: uma região, como us-central1.
INSIGHT_TYPE: o ID do tipo de insight é
UnderprovisionedCpuUsageInsight, UnderprovisionedMemoryUsageInsight ou OomProbabilityInsight,
que fornece insights sobre uso da CPU, memória e probabilidade de OOM, respectivamente.
API
Para receber insights e recomendações detalhadas sobre instâncias subprovisionadas usando a
API Recommendations, chame o
método insights.list
da seguinte maneira:
GET https://recommender.googleapis.com/v1beta1/projects/PROJECT-ID/locations/LOCATION/insightTypes/google.cloudsql.instance.INSIGHT_TYPE/insights
Substitua:
PROJECT_ID: o ID do projeto
LOCATION: uma região, como us-central1.
INSIGHT_TYPE: o ID do tipo de insight como UnderprovisionedCpuUsageInsight,
UnderprovisionedMemoryUsageInsight ou OomProbabilityInsight,
que fornece insights sobre uso da CPU, memória e probabilidade de OOM, respectivamente.
A tabela a seguir lista os insights e as recomendações que o recomendador de instâncias subprovisionadas
do Cloud SQL pode gerar para ajudar a evitar gargalos de uso elevado da CPU e da memória e minimizar a probabilidade de eventos de falta de memória.
Os subtipos estão visíveis nos resultados da gcloud e da API.
Insights
Recomendações
Com base nas tendências atuais de utilização da CPU, a instância será sinalizada como
tendo alto uso da CPU.
Subtipo: HIGH_CPU_UTILIZATION
Aumente o tamanho da CPU ou reduza o uso dela.
Subtipo: CHANGE_INSTANCE_SIZE
Com base nas tendências atuais de utilização de memória, a instância é sinalizada como tendo alto uso da memória.
Subtipo: HIGH_MEMORY_UTILIZATION.
Aumente o tamanho da memória ou reduza o uso dela.
Subtipo: CHANGE_INSTANCE_SIZE
Com base nas tendências de uso atuais, a instância está sinalizada como correndo o risco de incorrer em eventos futuros de OOM.
Subtipo: HIGH_OOM_PROBABILITY.
Aumente o tamanho da memória ou reduza o uso dela.
Subtipo: CHANGE_INSTANCE_SIZE
Aplicar recomendações
Avalie as recomendações com atenção e siga um destes procedimentos:
Para examinar a recomendação, clique em Visualizar instância.
Um banner aparecerá na parte superior da página com uma recomendação.
Para dispensar a recomendação de modo que ela não seja enfatizada e apareça escurecida,
clique em Dispensar.
Para fechar o painel sem aplicar ou dispensar a recomendação, clique em
Cancelar.
Otimizar o desempenho da instância
Para otimizar o desempenho da instância, faça o seguinte:
Edite a instância, se necessário, para
aumentar as vCPUs ou a memória. Como alternativa, alterne para um tipo de máquina com mais
vCPUs e menos memória. Você não precisa dimensionar a instância exatamente como recomendado. Use
o bom senso e o redimensionamento com base em como você pretende provisionar a instância.
Lembre-se de que quanto maior o tamanho, maior a latência operacional.
[[["Fácil de entender","easyToUnderstand","thumb-up"],["Meu problema foi resolvido","solvedMyProblem","thumb-up"],["Outro","otherUp","thumb-up"]],[["Difícil de entender","hardToUnderstand","thumb-down"],["Informações incorretas ou exemplo de código","incorrectInformationOrSampleCode","thumb-down"],["Não contém as informações/amostras de que eu preciso","missingTheInformationSamplesINeed","thumb-down"],["Problema na tradução","translationIssue","thumb-down"],["Outro","otherDown","thumb-down"]],["Última atualização 2025-09-03 UTC."],[],[],null,["# Reduce underprovisioned Cloud SQL instances\n\n\u003cbr /\u003e\n\n[MySQL](/sql/docs/mysql/recommender-underprovisioned \"View this page for the MySQL database engine\") \\| [PostgreSQL](/sql/docs/postgres/recommender-underprovisioned \"View this page for the PostgreSQL database engine\") \\| SQL Server\n\n\u003cbr /\u003e\n\n\u003cbr /\u003e\n\n|\n| **Preview**\n|\n|\n| This feature is subject to the \"Pre-GA Offerings Terms\" in the General Service Terms section\n| of the [Service Specific Terms](/terms/service-terms#1).\n|\n| Pre-GA features are available \"as is\" and might have limited support.\n|\n| For more information, see the\n| [launch stage descriptions](/products#product-launch-stages).\n\nThe underprovisioned instance [recommender](/recommender/docs/overview)\nhelps you detect instances that have high CPU and/or memory utilization.\nIt then provides recommendations for how to optimize the instance.\nThis page describes how this recommender works and how to use it.\n\nHow it works\n------------\n\nWhen there is high CPU and/or memory utilization detected, you see a recommendation to increase the size of your instance to reduce CPU and/or memory utilization at peak.\n| **Note:** Recommendations are generated daily.\n\nPricing\n-------\n\nThe underprovisioned instance recommender is in the Standard\n[Recommender pricing tier](/recommender/pricing).\n\nBefore you begin\n----------------\n\nBefore you can view recommendations and insights, do the following:\n\n- Ensure that you have the required [roles](/sql/docs/sqlserver/project-access-control#roles) so that you have permission to view and work with insights and recommendations.\n\n For more information about roles, see [understanding roles](/iam/docs/understanding-roles) and [granting IAM permissions](/iam/docs/granting-changing-revoking-access).\n-\n\n\n Enable the Recommender API.\n\n\n [Enable the API](https://console.cloud.google.com/flows/enableapi?apiid=recommender.googleapis.com)\n\nList underprovisioned instance recommendations\n----------------------------------------------\n\n### Console\n\nTo list recommendations about underprovisioned instances, follow these steps:\n\n1. Go to the **Cloud SQL Instances** page.\n\n [Go to Cloud SQL Instances](https://console.cloud.google.com/sql/instances)\n2. Click **View all** on the resize Cloud SQL instance recommender banner.\n\nAlternatively, follow these steps:\n\n1. Go to the **Recommendation Hub**.\n\n [Go to the Recommendation Hub](https://console.cloud.google.com/home/recommendations/)\n\n For more information, see\n [Getting started with Recommendation Hub](/recommender/docs/recommendation-hub/identify-configuration-problems).\n2. In the **Resize Cloud SQL instances to improve performance** card, click **View all**.\n\n3. Click the instances with the **Resize Cloud SQL instance** recommendation.\n\n### gcloud\n\nTo list recommendations about underprovisioned instances, run the\n[`gcloud recommender recommendations list`](/sdk/gcloud/reference/recommender/recommendations/list)\ncommand as follows: \n\n```\ngcloud recommender recommendations list \\\n--project=PROJECT_ID \\\n--location=LOCATION \\\n--recommender=google.cloudsql.instance.UnderprovisionedRecommender\n```\n\nReplace the following:\n\n- \u003cvar translate=\"no\"\u003ePROJECT_ID\u003c/var\u003e: Your project ID.\n- \u003cvar translate=\"no\"\u003eLOCATION\u003c/var\u003e: A region, such as `us-central1`.\n\n### API\n\nTo list recommendations about underprovisioned instances by using the\n[Recommendations API](/recommender/docs/using-api), call the\n[`recommendations.list`](/recommender/docs/reference/rest/v1beta1/projects.locations.recommenders.recommendations/list)\nmethod as follows: \n\n```\nGET https://recommender.googleapis.com/v1beta1/projects/PROJECT-ID/locations/LOCATION/recommenders/google.cloudsql.instance.UnderprovisionedRecommender/recommendations\n```\n\nReplace the following:\n\n- \u003cvar translate=\"no\"\u003ePROJECT_ID\u003c/var\u003e: Your project ID.\n- \u003cvar translate=\"no\"\u003eLOCATION\u003c/var\u003e: A region, such as `us-central1`.\n\nIf the recommender detects underprovisioned instances, it lists them in a\ntable. Each row shows the instance name, a brief recommendation, the current machine type,\nthe recommended machine type, the location, and the last refresh date.\n\nView insights and detailed recommendations\n------------------------------------------\n\n### Console\n\nTo view insights and detailed recommendations about an underprovisioned instance by using the\nGoogle Cloud console, click the recommendation button in the list of instances.\n\n### gcloud\n\nTo view insights and detailed recommendations about underprovisioned instances by using `gcloud`, run the\n[`gcloud recommender insights list`](/sdk/gcloud/reference/recommender/insights/list)\ncommand as follows: \n\n```\ngcloud recommender insights list \\\n--project=PROJECT_ID \\\n--location=LOCATION \\\n--insight-type=google.cloudsql.instance.INSIGHT_TYPE\n```\n\nReplace the following:\n\n- \u003cvar translate=\"no\"\u003ePROJECT_ID\u003c/var\u003e: Your project ID.\n- \u003cvar translate=\"no\"\u003eLOCATION\u003c/var\u003e: A region, such as `us-central1`.\n- \u003cvar translate=\"no\"\u003eINSIGHT_TYPE\u003c/var\u003e: The ID of the insight type is `UnderprovisionedCpuUsageInsight`, `UnderprovisionedMemoryUsageInsight`, or `OomProbabilityInsight`, which provide insights about CPU usage, memory, and OOM probability, respectively.\n\n### API\n\nTo view insights and detailed recommendations about underprovisioned instances by using the\n[Recommendations API](/recommender/docs/using-api), call the\n[`insights.list`](/recommender/docs/reference/rest/v1beta1/projects.locations.insightTypes.insights/list)\nmethod as follows: \n\n```\nGET https://recommender.googleapis.com/v1beta1/projects/PROJECT-ID/locations/LOCATION/insightTypes/google.cloudsql.instance.INSIGHT_TYPE/insights\n```\n\nReplace the following:\n\n- \u003cvar translate=\"no\"\u003ePROJECT_ID\u003c/var\u003e: Your project ID.\n- \u003cvar translate=\"no\"\u003eLOCATION\u003c/var\u003e: A region, such as `us-central1`.\n- \u003cvar translate=\"no\"\u003eINSIGHT_TYPE\u003c/var\u003e: The ID of the insight type as \\``UnderprovisionedCpuUsageInsight`, `UnderprovisionedMemoryUsageInsight`, or `OomProbabilityInsight`, which provide insights about CPU usage, memory, and OOM probability, respectively.\n\nThe following table lists the insights and recommendations that the Cloud SQL\nunderprovisioned instance recommender might generate to help you avoid bottlenecks from high CPU and memory\nusage and minimize the likelihood of out-of-memory events.\nThe subtypes are visible in the `gcloud` and API results.\n\nApply recommendations\n---------------------\n\nEvaluate the recommendations carefully and do any of the following:\n\n- To examine the recommendation, click **View instance**.\n\n A banner appears at the top of the page providing a recommendation.\n- To dismiss the recommendation so that it's de-emphasized and appears dimmed,\n click **Dismiss**.\n\n- To close the panel without applying or dismissing the recommendation, click\n **Cancel**.\n\n### Optimize the performance of your instance\n\nTo optimize your instance's performance, do the following:\n\n- [Optimize high memory usage](/sql/docs/sqlserver/optimize-high-memory-usage)\n\n- [Optimize high CPU usage](/sql/docs/sqlserver/optimize-cpu-usage)\n\n\u003c!-- --\u003e\n\n- [Edit](/sql/docs/sqlserver/edit-instance) the instance, if required, to\n increase the vCPUs or memory. Alternatively, switch to a machine type with more\n vCPUs and more memory. You don't need to rightsize the instance exactly as recommended. Use your\n judgement and resize based on how you intend to provision the instance.\n Keep in mind that the bigger the size, the greater the operational latency.\n\n | **Caution:** This operation can lead to an increase in cost. Additionally, it triggers a restart, which brings downtime to the instance.\n\nYou can also [export these recommendations to BigQuery](/recommender/docs/bq-export/export-recommendations-to-bq)\nand then examine them using [Looker Studio](/bigquery/docs/visualize-looker-studio) or [Looker](/bigquery/docs/looker).\n\nWhat's next\n-----------\n\n- [Monitor disk availability](/sql/docs/sqlserver/using-ood-recommender)\n- [Reduce idle Cloud SQL instances](/sql/docs/sqlserver/recommender-sql-idle)\n- [Blog: Maximize your Cloud ROI](https://cloud.google.com/blog/products/management-tools/active-assist-comes-to-google-cloud)\n- [Blog: Do more with less](https://cloud.google.com/blog/products/databases/reduce-cloud-sql-costs-with-optimizations-by-active-assist)\n- [Google Cloud recommenders](/recommender/docs/recommenders)"]]
