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.
