PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #177
Your company is rapidly expanding its user base across North America, nearly doubling in the last 6-months. This expansion causes a substantial increase in query volume on your mission- critical…
The correct answer is C. Review Cloud SQL System Insights for the instance, and analyze CPU, memory, and storage. Start by using Cloud-SQL’s System-Insights dashboard to pinpoint whether CPU, memory, or disk I/O is saturating during peak loads. Analyzing these resource-utilization charts will reveal the root cause, letting you choose the right scaling strategy (vertical resize, read…
Question
Your company is rapidly expanding its user base across North America, nearly doubling in the last 6-months. This expansion causes a substantial increase in query volume on your mission- critical Cloud SQL database. This has led to noticeable performance issues and slower query response times. You suspect that your Cloud SQL instance may not be able to handle the incremental load. You need to identify the root cause of this performance bottleneck and ensure that your database can scale with your growing user base. What should you do-
Options
- AMigrate the database to Spanner.
- BEvaluate the application connection pooling configuration settings.
- CReview Cloud SQL System Insights for the instance, and analyze CPU, memory, and storage
- DCreate two Cloud SQL instances, and split the workload between them.
How the community answered
(30 responses)- A17% (5)
- B3% (1)
- C70% (21)
- D10% (3)
Explanation
Start by using Cloud-SQL’s System-Insights dashboard to pinpoint whether CPU, memory, or disk I/O is saturating during peak loads. Analyzing these resource-utilization charts will reveal the root cause, letting you choose the right scaling strategy (vertical resize, read replicas, or sharding) rather than guessing.
Topics
Community Discussion
No community discussion yet for this question.