Subject Re: [firebird-support] Measure the effectiveness of incrementing page buffer...
Author Javier Cintron
Thank you very much!
On Thursday, May 3, 2018, 3:30:32 AM CDT, Dimitry Sibiryakov sd@... [firebird-support] <firebird-support@yahoogroups.com> wrote:


 

03.05.2018 7:56, Javier Cintron fcintrono@... [firebird-support] wrote:
> Firebird ver 2.5.7.27050 64 bits
> Windows Server 2012R2
>
> ┬┐Is there a way to calculate the effectiveness of incrementing the page cache buffer ?

select cast(mon$page_reads as double precision)/mon$page_fetches from mon$io_stats
where mon$stat_group=0
If the value is getting lower - you are on the right way.

--
WBR, SD.