Hi again,

> Hi Eduardo,
>
> [snip]
>
>> Firebird.conf:
>>
>> ---------------------
>>
>> DefaultDbCachePages = 1024
>>
>> #FileSystemCacheThreshold = 65536 (commented out)
>>
>> #FileSystemCacheSize = 0 (commented out)
>>
>>
>> Server environment:
>>
>> --------------------------
>>
>> CPU utilization: 11%
>>
>> Memory utilization: 11 GB (out of 32)
>>
>>
>> Note.- Even when the DB performance is down, this values are in the same
>> range or even lower. No swapping.
>>
>>
>> gstat output (normal performance):
>>
>> ---------------------------------------------------------
>>
>> Database header page information:
>> Flags 0
>> Checksum 12345
>> Generation 19572161
>> Page size 16384
>> ODS version 11.2
>> Oldest transaction 18709808
>> Oldest active 18953295
>> Oldest snapshot 18851591
>> Next transaction 19520857
>> Bumped transaction 1
>> Sequence number 0
>> Next attachment ID 50438
>> Implementation ID 26
>> Shadow count 0
>> Page buffers 3000
>
> Possibly a bit high for Classic, but might be ok. You might increase
> that to e.g. 2048 and spend more RAM on the temporary storage module for
> ordering/group by results etc.
>
>
>> Next header page 0
>> Database dialect 1
>> Creation date Jul 7, 2015 7:00:57
>> Attributes no reserve

Btw, it is not a good idea to run a read/write production database with
the "no reserve" option.



--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.