What should you do first?

You support a consumer inventory application that runs on a multi-region instance of Cloud Spanner. A customer opened a support ticket to complain about slow response times. You notice a Cloud Monitoring alert about high CPU utilization. You want to follow Google-recommended practices to address the CPU performance issue.

What should you do first?
A . Increase the number of processing units.
B . Modify the database schema, and add additional indexes.
C . Shard data required by the application into multiple instances.
D . Decrease the number of processing units.

Answer: A

Explanation:

In case of high CPU utilization like, mentioned in question, refer: https://cloud.google.com/spanner/docs/identify-latency-point#:~:text=Check%20the%20CPU%20utilization%20of%20the%20instance.%20If%20the%20CPU% 20utilization%20of%20the%20instance%20is%20above%20the%20recommended%20level%2C%20y ou%20should%20manually%20add%20more%20nodes%2C%20or%20set%20up%20auto%20scaling. "Check the CPU utilization of the instance. If the CPU utilization of the instance is above the recommended level, you should manually add more nodes, or set up auto scaling." Indexes and schema are reviewed post identifying query with slow performance.

Refer: https://cloud.google.com/spanner/docs/troubleshooting-performance-regressions#review-schema

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments