A team uses Cloud SQL for PostgreSQL. They receive an alert that the database's CPU utilization is above 95% for the past 30 minutes. Queries are taking longer than usual. They want to investigate without causing further impact. What should they do first?
Trap 1: Increase the number of vCPUs of the Cloud SQL instance
Scaling up is a mitigation but should be done after understanding the cause.
Trap 2: Restart the Cloud SQL instance to clear the cache
Restarting causes downtime and does not fix the root cause.
Trap 3: Migrate the database to Cloud Spanner
Migration is a long-term project, not an immediate investigation step.
- A
Increase the number of vCPUs of the Cloud SQL instance
Why wrong: Scaling up is a mitigation but should be done after understanding the cause.
- B
Restart the Cloud SQL instance to clear the cache
Why wrong: Restarting causes downtime and does not fix the root cause.
- C
Migrate the database to Cloud Spanner
Why wrong: Migration is a long-term project, not an immediate investigation step.
- D
Use Cloud SQL Query Insights to find the most time-consuming queries
Query Insights shows top queries by CPU and latency.