| Subject | FB3 Memory usage |
|---|---|
| Author | Si Carter |
| Post date | 2016-11-03T06:37:01Z |
Hi,
I recently installed FB v3.0.1.32609 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.
Other stats:
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.
regards
Si