Do we agree that it's not possible to scale the query-service? The data seems to be stored in a local SQLite DB, which prevents it from being scaled? How do you manage high availability?

This is known https://github.com/SigNoz/signoz/issues/941, but query service is rarely the issue

Maybe, but that makes it hard to “HA” the service. You end up with an alerting component that's out of order.

You end up with an alerting component that's out of order.

What is the out of order you are referring to here?