Hello Rudi,
Usually, queries with the dozens of millions of index operations are
responsible for high CPU usage.
You can find them with HQbird MonLogger: get snapshot during the high
CPU peak, open it, open tab Statements (disable check "Link to selected
attachment"), and sort on
10.05.2018 15:12, Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support]
wrote:
> We have no way of debugging every single one of the applications being run,
> and there is no single obvious operation that could justify this high cpu
> usage.
>
> Is there a way to monitor queries not only
Hello
I have a situation which is hard to debug. We are running about 50 databases
(firebird 3.0.3) on a single server, all of them connected to different
applications.
CPU usage is normaly low, but sporadically it will peak at 100% and cause
problems for all the connections.
We have no way