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 record_idx_reads.
If there are many records - Remove prepared
The queries with the highest numbers of record_idx_reads are those which
responsible for high CPU usage.
Regards,
Alexey Kovyazin
IBSurgeon
On 10.05.2018 16:12, Rudi Feijó rudi.fe...@multidadosti.com.br
[firebird-support] wrote:
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 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 for the time they take, but for
the CPU they use?
A few years ago I tried FBScanner, but as far as I remember it didn’t
gauge
cpu usage.
Atenciosamente,
Rudi Feijó
Multidados Informática Ltda.
* (11) 2579-8789
* <mailto:ariane.cut...@multidadosti.com.br>
rudi.fe...@multidadosti..com.br
* <http://www.multidadosti.com.br/> www.multidadosti.com.br
* <http://www.whatsappmailing.com.br> www.whatsappmailing.com.br
[Non-text portions of this message have been removed]