Subject Diagnosing CPU usage
Author Rudi Feijó
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@...

* <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]