This recommendation identifies low memory/cpu utilization of Cloud SQL that can be stoped or deleted.

Recommendation Logic
Trigger when:

• CPU utilization < X% (default 30%).
• Memory usage < Y% (default 30%).
• Spare Capacity < X% (default 30%).
• Instance running but no connections, user_connections = 0.

Estimated Savings
Current instance cost – recommended instance cost.

• The Cloud SQL Admin API must be enabled on the GCP project.
  1. Open the Google Cloud Console [API Library] (https://console.cloud.google.com/apis/library).
  2. Select your target project from the top drop-down menu.
  3. Search for "Cloud SQL Admin API" in the search bar.
  4. Click on the Cloud SQL Admin API result.
  5. Click the blue ENABLE button.
• Predefined role :roles/cloudsql.viewer.
• If you are using a custom IAM role instead of predefined roles, the individual permissions to add are:
  1. cloudsql.instances.list
  2. cloudsql.tiers.list

1. Days To Check, default=30 days.
2. CPU Utilization Threshold (%), default=30.
3. CPU Spare Capacity (%), default=30.
4. Memory Utilization Threshold (%), default=30.
5. Memory Spare Capacity (%), default=5.

Umbrella.

No.

Identifying Cloud SQL instances that are idle based on low CPU utilization.

Trigger Logic
CPU utilization = 0 during the days to check period.

Completion Logic
The instance wont arrive in the invoice.

Estimated Savings
Current instance cost.

• The Cloud SQL Admin API must be enabled on the GCP project.
  1. Open the Google Cloud Console [API Library] (https://console.cloud.google.com/apis/library).
  2. Select your target project from the top drop-down menu.
  3. Search for "Cloud SQL Admin API" in the search bar.
  4. Click on the Cloud SQL Admin API result.
  5. Click the blue ENABLE button.
• Predefined role :roles/cloudsql.viewer.
• If you are using a custom IAM role instead of predefined roles, the individual permissions to add are:
  1. cloudsql.instances.list
  2. cloudsql.tiers.list

1. Days To Check, default=30 days.
2. Min Active Days:The minimum cumulative number of active days for the resource within the Activity Period, not consecutive (Example: Only recommend on servers running at least 15 days in the period). (Default= 10)

Umbrella.

No.