Re: [firebird-support] Diagnosing CPU usage

2018-05-11 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
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

Re: [firebird-support] Diagnosing CPU usage

2018-05-10 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
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

[firebird-support] Diagnosing CPU usage

2018-05-10 Thread Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support]
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