| Subject | Re: [firebird-support] Diagnosing CPU usage |
|---|---|
| Author | Alexey Kovyazin |
| Post date | 2018-05-11T08:20:12Z |
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.feijo@... [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.cutlac@...> rudi.feijo@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]