Re: [firebird-support] Diagnosing CPU usage

[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 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

*  
rudi.fe...@multidadosti..com.br


*  www.multidadosti.com.br
*  www.whatsappmailing.com.br

[Non-text portions of this message have been removed]

Re: [firebird-support] Diagnosing CPU usage

[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 for the time they take, but for
> the CPU they use?

   Queries are not the only thing that consume CPU. Use Process Explorer to get 
call stack 
for CPU consuming thread several times in row. It may provide you an idea what 
this thread 
is doing. Don't forget to load PDB files to see function names in the stack.


-- 
   WBR, SD.

[firebird-support] Diagnosing CPU usage

[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 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

*   rudi.fe...@multidadosti.com.br

*   www.multidadosti.com.br 
*   www.whatsappmailing.com.br

 

 



[Non-text portions of this message have been removed]