|Subject||FB3 Memory usage|
I recently installed FB v188.8.131.52609 on Windows server 2008.
This is a dual installation as I still have 2.5.3 installed.
I noticed that my fb3 service is using in excess of 4gb memory, this in itself is not a problem as the server has plenty of ram. It's probably my lack of understanding but it appears I have memory allocated to what appears to be orphaned connections.
Given this sql
SELECT ma.MON$ATTACHMENT_NAME, ma.MON$USER, a.MON$STAT_ID, a.MON$STAT_GROUP, a.MON$MEMORY_USED, a.MON$MEMORY_ALLOCATED, a.MON$MAX_MEMORY_USED, a.MON$MAX_MEMORY_ALLOCATED
FROM MON$MEMORY_USAGE a
LEFT JOIN MON$ATTACHMENTS ma ON (ma.MON$STAT_ID = a.MON$STAT_ID)
ORDER BY ma.MON$ATTACHMENT_NAME
it produces the following results, STAT_ID 1 is the one I am more concerned about at this point.
[null] [null] 138 2 3248 0 4272 0
[null] [null] 115 2 44048 0 44048 0
[null] [null] 218 3 22104 8112 87984 73688
[null] [null] 116 3 22384 8112 91760 73688
[null] [null] 95 3 21192 24336 2121800 2121568
[null] [null] 1 0 58128176 81557240 1685336336 2771125200
Previously it was using in excess of 5gb of ram, a restart bought it back to normal, but it soon escalated to 3gb (within seconds) and now to 4gb ram.
The database has only 4 normal connections, plus Cache Writer and Garbage Collector, so it's not under unusual usage at the mo.
Oldest transaction 735636
Oldest active 735637
Oldest snapshot 735120
Next transaction 735644
Sorry if this is a duplicate question, have tried searching but not had many answers.