That's unfortunate. The most frustrating part about cloud services are exactly these kinds intermittent performance and responsiveness issues.
That's unfortunate. The most frustrating part about cloud services are exactly these kinds intermittent performance and responsiveness issues.
You have to consider the rate at which the raw data is collected from the replicas ---and the jitter across all of them!-- then the rate at which that data is aggregated, and so on. (The above assumes that Cloud Spanner uses Borgmon for monitoring.) Any hiccups in the collection itself will result in less noise if you look at 5m vs e.g. 1m. You could increase the sampling rate, but then you're making your DB replicas spend more precious cycles on work that is not serving queries or replicating data.
You're right, but that's basically 'by-design' as far as the internet is concerned.