PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #108
Your customer has a global chat application that uses a multi-regional Cloud Spanner instance. The application has recently experienced degraded performance after a new version of the application…
The correct answer is C. Use SQL statements to analyze SPANNER_SYS.READ_STATS* tables. Read statistics provide insight into how an application is using the database, and are useful when investigating performance issues. https://cloud.google.com/spanner/docs/introspection/read-statistics
Question
Your customer has a global chat application that uses a multi-regional Cloud Spanner instance. The application has recently experienced degraded performance after a new version of the application was launched. Your customer asked you for assistance. During initial troubleshooting, you observed high read latency. What should you do?
Options
- AUse query parameters to speed up frequently executed queries.
- BChange the Cloud Spanner configuration from multi-region to single region.
- CUse SQL statements to analyze SPANNER_SYS.READ_STATS* tables.
- DUse SQL statements to analyze SPANNER_SYS.QUERY_STATS* tables.
How the community answered
(36 responses)- A3% (1)
- B6% (2)
- C83% (30)
- D8% (3)
Explanation
Read statistics provide insight into how an application is using the database, and are useful when investigating performance issues. https://cloud.google.com/spanner/docs/introspection/read-statistics
Topics
Community Discussion
No community discussion yet for this question.