QuestionQ72

VerifiedDeploy scalable and highly available databases in Google Cloud

A customer runs a global chat application on a multi-regional Cloud Spanner instance. The application recently showed degraded performance after a new application version was released. The customer asks for assistance. During initial troubleshooting, high read latency is observed. What should you do?

Explanation

Cloud Spanner SPANNER_SYS.READ_STATS* tables provide SQL-accessible statistics for read shapes, including execution counts, CPU time, locking delay, client wait time, and leader-refresh delay. These metrics help isolate the reads responsible for performance degradation and are particularly relevant to diagnosing read latency in a multi-region configuration.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!