Improve performance with Cloud SQL Enterprise Plus edition
This page describes the following types of Cloud SQL Enterprise Plus edition recommenders:
- Upgrade to Cloud SQL Enterprise Plus edition for near-zero maintenance downtime
- Upgrade to Cloud SQL Enterprise Plus edition and enable data cache to improve read performance
- Upgrade to Cloud SQL Enterprise Plus edition with enabling data cache
- Enable data cache to improve read performance
The following sections describe how these recommenders work and how to use them.
Pricing
The recommenders described on this page are all in the standardRecommender pricing tier.
Before you begin
Before you can view recommendations and insights, do the following:
- To get the permissions to view and work with insights and recommendations,ensure that you have the requiredroles.
For more information about roles, seeunderstanding roles andgranting Identity and Access Management (IAM) permissions.Tasks Roles View recommendations One of these roles: recommender.cloudsqlViewerorcloudsql.viewer.Apply recommendations One of these roles: recommender.cloudsqlAdmin,cloudsql.editor, orcloudsql.admin. Enable the Recommender API.
Roles required to enable APIs
To enable APIs, you need the Service Usage Admin IAM role (
roles/serviceusage.serviceUsageAdmin), which contains theserviceusage.services.enablepermission.Learn how to grant roles.
Upgrade to Cloud SQL Enterprise Plus edition for near-zero maintenance downtime
The Cloud SQL Enterprise Plus edition for near-zero maintenance downtimerecommenderhelps you detect instances that are either critical and take a long time to stop during maintenance or their maintenance has been deferred. It analyzes instance metadata and data about maintenance.
If your instance is a production instance and takes a long time to stop during maintenance or its maintenance has been deferred, it is recommended to upgrade to Cloud SQL Enterprise Plus edition so that you instances will have near-zero maintenance downtime.Recommendations are generated daily.
List near-zero downtime recommendations
You can list upgrade to Cloud SQL Enterprise Plus edition for near-zero maintenance downtime recommendationsusing the Google Cloud console,gcloud CLI, or the Recommender API.
Console
To list upgrade to Cloud SQL Enterprise Plus edition recommendations, follow these steps:
Go to theCloud SQL Instances page.
On theImprove instance health by investigating issues and acting on recommendations banner, clickExpand Details.
Alternatively, follow these steps:
Go to theActive Assist. See alsoFind and apply recommendations with the Recommendations.
For more information, seeGetting started with the Recommendation Hub.
In theAll recommendations card, clickPerformance.
gcloud
Run thegcloud recommender insights list command as follows:
gcloud recommender recommendations list \--project=PROJECT_ID \--location=LOCATION \--recommender=google.cloudsql.instance.PerformanceRecommender \--filter=recommenderSubtype=UPGRADE_TO_ENTERPRISE_PLUS
Replace the following:
PROJECT_ID: Your project ID.LOCATION: A region, such asus-central1.
API
Call theinsights.list method as follows:
GET https://recommender.googleapis.com/v1beta1/projects/PROJECT_ID/locations/LOCATION/recommenders/google.cloudsql.instance.PerformanceRecommender/recommendations
Replace the following:
PROJECT_ID: Your project ID.LOCATION: A region, such asus-central1.
If the recommender detects instances that can be upgraded to Cloud SQL Enterprise Plus edition, they are listed in a table showing the instance name, a brief recommendation, the current machine type, the recommended machine type, the location, and the last refresh date.
View insights and detailed recommendations
You can view insights and detailed recommendations about instances that can be upgraded to Cloud SQL Enterprise Plus edition using the Google Cloud console,gcloud CLI, or the Recommender API.
Console
Do one of the following:
On thePerformance Recommendations page, click thePerformancerecommendations card and then clickNot optimized with Enterprise Plus.The recommendation panel appears, which contains insights and detailedrecommendations for the instance.
On theInstances page, clickNot optimized with Enterprise Plus. Thelist of instances displays only those instances for which therecommendation applies.
gcloud
Run thegcloud recommender insights list command as follows:
gcloud recommender insights list \--project=PROJECT_ID \--location=LOCATION \--insight-type=google.cloudsql.instance.PerformanceInsight \--filter=insightSubtype=INSIGHT_SUBTYPE
Replace the following:
PROJECT_ID: your project IDLOCATION: a region, such asus-central1.INSIGHT_SUBTYPE: set this parameter to one of the following:CRASH_RECOVERY_CAUSED_HIGH_MAINTENANCE_DOWNTIME: displayinsights for the total number of crash recoveries for yourinstanceMAINTENANCE_DEFERRED_MULTIPLE_TIMES: displayinsights for the total number of maintenances deferred for your instance
API
Call theinsights.list method as follows:
GET https://recommender.googleapis.com/v1/projects/PROJECT_ID/locations/LOCATION/insightTypes/google.cloudsql.instance.PerformanceInsight/insights
Replace the following:
PROJECT_ID: Your project ID.LOCATION: A region, such asus-central1.
A panel appears showing insights about metrics or information that the Insights highlight.
Apply recommendations
To implement this recommendation, do the following:
- To upgrade to Cloud SQL Enterprise Plus edition, clickNot optimized with Enterprise Plus edition in theIssues column. AnUpgrade to Enterprise Plus edition window displays providing a recommendation. To proceed with an upgrade, clickEdit >Upgrade. For more information on upgrading your instance, seeUpgrade an instance to Cloud SQL Cloud SQL Enterprise Plus edition by using in-place upgrade. For more information on zero downtime, seedata cache.
Upgrade to Cloud SQL Enterprise Plus edition and enable data cache to improve read performance
The upgrade to Cloud SQL Enterprise Plus edition and enable data cache to improve read performancerecommenderhelps you detect instances which are critical and whose cache hit rate is low.
The upgrade to Cloud SQL Enterprise Plus edition and enable data cache to improve read performance recommender analyzes instance metadata and metrics about cache hit rate. If the instance is a production instance and its cache hit rate is low, it is recommended to upgrade to Cloud SQL Enterprise Plus edition and enable the data cache to improve read performance. Recommendations are generated daily.
List instances that can be upgraded to Cloud SQL Enterprise Plus edition with enabling data cache to improve read performance recommendations
You can list upgrade to Cloud SQL Enterprise Plus edition with enabling data cache to improve read performance recommendationsusing the Google Cloud console,gcloud CLI, or the Recommender API.
Console
To list upgrade to Cloud SQL Enterprise Plus edition recommendations, follow these steps:
Go to theCloud SQL Instances page.
On theImprove instance health by investigating issues and acting on recommendations banner, clickExpand Details.
Alternatively, follow these steps:
Go to theActive Assist. See alsoFind and apply recommendations with the Recommendations.
For more information, seeGetting started with the Recommendation Hub.
In theAll recommendations card, clickPerformance.
gcloud
To list upgrade to Cloud SQL Enterprise Plus edition with enabling data cache to improve read performance recommendations, run thegcloud recommender recommendations listcommand as follows:
gcloud recommender recommendations list \--project=PROJECT_ID \--location=LOCATION \--recommender=google.cloudsql.instance.PerformanceRecommender \--filter=recommenderSubtype=UPGRADE_TO_ENTERPRISE_PLUS_AND_ENABLE_DATA_CACHE
Replace the following:
PROJECT_ID: your project IDLOCATION: a region where your instances are located, such asus-central1
API
To list upgrade to Cloud SQL Enterprise Plus edition with enabling data cache to improve read performance recommendations, call therecommendations.listmethod as follows:
GET https://recommender.googleapis.com/v1/projects/PROJECT_ID/locations/LOCATION/recommenders/google.cloudsql.instance.PerformanceRecommender/recommendations
Replace the following:
PROJECT_ID: your project IDLOCATION: a region where your instances are located, such asus-central1.
If the recommender detects instances that can be upgraded to Cloud SQL Enterprise Plus edition, they are listed in a table showing the instance name, a brief recommendation, the current machine type, the recommended machine type, the location, and the last refresh date.
View insights and detailed recommendations
You can view insights and detailed recommendations about instances that can be upgraded to Cloud SQL Enterprise Plus edition using the Google Cloud console,gcloud CLI, or the Recommender API.
Console
Do one of the following:
- On thePerformance Recommendations page, click thePerformancerecommendations card and then clickNot optimized with Enterprise Plus edition.
The recommendation panel appears, which contains insights and detailedrecommendations for the instance.
- On theInstances page, clickNot optimized with Enterprise Plus edition.
Thelist of instances displays only those instances for which therecommendation applies.
gcloud
To view insights and detailed recommendations about an instance that can be upgraded, run thegcloud recommender insights listcommand as follows:
gcloud recommender insights list \--project=PROJECT_ID \--location=LOCATION \--insight-type=google.cloudsql.instance.PerformanceInsight \--filter=insightSubtype=READ_HEAVY_WORKLOAD
Replace the following:
PROJECT_ID: your project IDLOCATION: a region where your instances are located, such asus-central1
API
Call theinsights.list method as follows:
GET https://recommender.googleapis.com/v1beta1/projects/PROJECT_ID/locations/LOCATION/insightTypes/google.cloudsql.instance.PerformanceInsight/insights
Replace the following:
PROJECT_ID: your project IDLOCATION: a region where your instances are located, such asus-central1
A panel appears showing insights about metrics or information that the Insights highlight.
Apply recommendations
To implement this recommendation, do the following:
- To upgrade to Cloud SQL Enterprise Plus edition, clickNot optimized with Enterprise Plus editionin theIssues column. AnUpgrade to Enterprise Plus edition window displays providing a recommendation. To proceed with an upgrade, clickEdit >Upgrade. For more information on upgrading your instance, seeUpgrade an instance to Cloud SQL Cloud SQL Enterprise Plus edition by using in-place upgrade. For more information on zero downtime, seedata cache.
Upgrade to Cloud SQL Enterprise Plus edition with enabling data cache
The upgrade to Cloud SQL Enterprise Plus edition with enabling data cacherecommenderhelps you detect instances which are critical and take a long time to stop during maintenance or theirmaintenance has been deferred and their cache hit rate is low.
The Cloud SQL Enterprise Plus edition with enabling data cache recommender analyzes instance metadata and metrics.
If your instance is a production instance and takes a long time to stop during maintenance or its maintenance has been deferred and its cache hit rate is low, it is recommended to upgrade to Cloud SQL Enterprise Plus edition and enable data cache so that your instances have near-zero maintenance downtime and improved read performance.Recommendations are generated daily.
List Cloud SQL instances that can be upgraded to Cloud SQL Enterprise Plus edition with enabling data cache recommendations
You can list upgrades to Cloud SQL Enterprise Plus edition when enabling data cache recommendationsusing the Google Cloud console,gcloud CLI, or the Recommender API.
Console
To list upgrade to Cloud SQL Enterprise Plus edition recommendations, follow these steps:
Go to theCloud SQL Instances page.
On theImprove instance health by investigating issues and acting on recommendations banner, clickExpand Details.
Alternatively, follow these steps:
Go to theActive Assist. See alsoFind and apply recommendations with the Recommendations.
For more information, seeGetting started with the Recommendation Hub.
In theAll recommendations card, clickPerformance.
gcloud
To list upgrade to Cloud SQL Enterprise Plus edition with enabling data cache recommendations, run thegcloud recommender recommendations listcommand as follows:
gcloud recommender recommendations list \--project=PROJECT_ID \--location=LOCATION \--recommender=google.cloudsql.instance.PerformanceRecommender \--filter=recommenderSubtype=UPGRADE_TO_ENTERPRISE_PLUS_AND_ENABLE_DATA_CACHE
Replace the following:
PROJECT_ID: your project IDLOCATION: a region where your instances are located, such asus-central1
API
To list upgrade to Cloud SQL Enterprise Plus edition with enabling data cache recommendations, call therecommendations.listmethod as follows:
GET https://recommender.googleapis.com/v1/projects/PROJECT_ID/locations/LOCATION/recommenders/google.cloudsql.instance.PerformanceRecommender/recommendations
Replace the following:
PROJECT_ID: your project IDLOCATION: a region where your instances are located, such asus-central1
If the recommender detects instances that can be upgraded to Cloud SQL Enterprise Plus edition with enabling data cache, they are listed in a table showing the instance name, a brief recommendation, the current machine type, the recommended machine type, the location, and the last refresh date.
View insights and detailed recommendations
You can view insights and detailed recommendations about instances that can be upgraded to Cloud SQL Enterprise Plus edition using the Google Cloud console,gcloud CLI, or the Recommender API.
Console
Do one of the following:
On thePerformance Recommendations page, click thePerformancerecommendations card and then clickNot optimized with Enterprise Plus.The recommendation panel appears, which contains insights and detailedrecommendations for the instance.
On theInstances page, clickNot optimized with Enterprise Plus. Thelist of instances displays only those instances for which therecommendation applies.
gcloud
To view insights and detailed recommendations about an instance that can be upgraded, run thegcloud recommender insights listcommand as follows:
gcloud recommender insights list \--project=PROJECT_ID \--location=LOCATION \--insight-type=google.cloudsql.instance.PerformanceInsight \--filter=insightSubtype=INSIGHT_SUBTYPE
Replace the following:
PROJECT_ID: your project IDLOCATION: a region where your instances are located, such asus-central1INSIGHT_SUBTYPE: set this parameter to one of the following:CRASH_RECOVERY_CAUSED_HIGH_MAINTENANCE_DOWNTIME: displayinsights for the total number of crash recoveries for yourinstanceMAINTENANCE_DEFERRED_MULTIPLE_TIMES: displayinsights for the total number of maintenances deferred for your instanceREAD_HEAVY_WORKLOAD: displayinsights about CPU usage
API
Call theinsights.list method as follows:
GET https://recommender.googleapis.com/v1beta1/projects/PROJECT_ID/locations/LOCATION/insightTypes/google.cloudsql.instance.PerformanceInsight/insights
Replace the following:
PROJECT_ID: Your project ID.LOCATION: A region, such asus-central1.
A panel appears showing insights about metrics or information that the Insights highlight.
Apply recommendations
To implement this recommendation, do the following:
- To upgrade to Cloud SQL Enterprise Plus edition, clickNot optimized with Enterprise Plus edition in theIssues column. AnUpgrade to Enterprise Plus edition window displays providing a recommendation. To proceed with an upgrade, clickEdit >Upgrade. For more information on upgrading your instance, seeUpgrade an instance to Cloud SQL Cloud SQL Enterprise Plus edition by using in-place upgrade. For more information on data cache, seedata cache. For more information on near-zero downtime, seenear-zero downtime.
Enable data cache to improve read performance
The enable data cache to improve read performancerecommenderhelps you detect instances which are critical and whose cache hit rate is low.
The Cloud SQL Enterprise Plus edition with enabling data cache to improve read performance recommender analyzes instance metadata and metrics about the cache hit rate.
If your instance is a production instance and its cache hit rate is low, it is recommended to enable the data cache to improve read performance.Recommendations are generated daily.
List Cloud SQL instances qualifying for Enable data cache to improve read performance recommendations
You can list enable data cache to improve read performance recommendations byusing the Google Cloud console,gcloud CLI, or the Recommender API.
Console
To list upgrade to Cloud SQL Enterprise Plus edition recommendations, follow these steps:
Go to theCloud SQL Instances page.
On theImprove instance health by investigating issues and acting on recommendations banner, clickExpand Details.
Alternatively, follow these steps:
Go to theActive Assist. See alsoFind and apply recommendations with the Recommendations.
For more information, seeGetting started with the Recommendation Hub.
In theAll recommendations card, clickPerformance.
gcloud
To list enable data cache to improve read performance recommendations, run thegcloud recommender recommendations listcommand as follows:
gcloud recommender recommendations list \--project=PROJECT_ID \--location=LOCATION \--recommender=google.cloudsql.instance.PerformanceRecommender \--filter=recommenderSubtype=ENABLE_DATA_CACHE
Replace the following:
PROJECT_ID: your project ID.LOCATION: a region where your instances are located, such asus-central1.
API
To list enable data cache to improve read performance recommendations, call therecommendations.listmethod as follows:
GET https://recommender.googleapis.com/v1beta1/projects/PROJECT_ID/locations/LOCATION/recommenders/google.cloudsql.instance.PerformanceRecommender/recommendations
Replace the following:
PROJECT_ID: your project ID.LOCATION: a region where your instances are located, such asus-central1.
If the recommender detects instances whose data cache can be enabled, they are listed in a table showing the instance name, a brief recommendation, the current machine type, the recommended machine type, the location, and the last refresh date.
View insights and detailed recommendations
You can view insights and detailed recommendations about instances that can be upgraded to Cloud SQL Enterprise Plus editionusing the Google Cloud console,gcloud CLI, or the Recommender API.
Console
Do one of the following:
On thePerformance Recommendations page, click thePerformancerecommendations card and then clickNot optimized with Enterprise Plus.The recommendation panel appears, which contains insights and detailedrecommendations for the instance.
On theInstances page, clickNot optimized with Enterprise Plus. Thelist of instances displays only those instances for which therecommendation applies.
gcloud
To view insights and detailed recommendations about an instance that can be upgraded, run thegcloud recommender insights listcommand as follows:
gcloud recommender insights list \--project=PROJECT_ID \--location=LOCATION \--insight-type=google.cloudsql.instance.PerformanceInsight \--filter=insightSubtype=READ_HEAVY_WORKLOAD
Replace the following:
PROJECT_ID: your project IDLOCATION: a region where your instances are located, such asus-central1
API
Call theinsights.list method as follows:
GET https://recommender.googleapis.com/v1/projects/PROJECT_ID/locations/LOCATION/insightTypes/google.cloudsql.instance.PerformanceInsight/insights
Replace the following:
PROJECT_ID: Your project ID.LOCATION: A region, such asus-central1.
A panel appears showing insights about metrics or information that the Insights highlight.
Apply recommendations
To implement this recommendation, do the following:
- To upgrade to Cloud SQL Enterprise Plus edition, clickNot optimized with Enterprise Plus edition in theIssues column. AnUpgrade to Enterprise Plus edition window displays providing a recommendation. To proceed with an upgrade, clickEdit >Upgrade >Customize your instance >Enable data cache. For more information on upgrading your instance, seeUpgrade an instance to Cloud SQL Cloud SQL Enterprise Plus edition by using in-place upgrade.
What's next
Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2026-02-19 UTC.