Hello Dimitry, Thank you.
I have checked the monitoring table, the sum of active memory usage is 160MB, the max usage around 290MB. But the firebird process takes up ca. 730MB. How can I understand this gap? Also the memory usage of the firebird.exe increases over the time till the max of 32Bit (2GB). This problem occurred only recently with no major changes in our database. Maybe windowsupdates have been a part of the problem? The clients uses firebird ODBC (MS Access) and some clients are written in C. Thanks a lot. -----Ursprüngliche Nachricht----- Von: firebird-support@yahoogroups.com <firebird-support@yahoogroups.com> Gesendet: Dienstag, 3. September 2019 12:28 An: firebird-support@yahoogroups.com Betreff: Re: [firebird-support] CpuAffinityMask on firebird 3.X and firebird memory leakage 03.09.2019 12:10, 'Check_Mail' check_m...@satron.de [firebird-support] wrote: > if we use the default firebird.conf with #CpuAffinityMask = 0, does > firebird use all cpus/cores? Or should I set it to 15 for 4 cores? I > have found some information for the > 2.5 only. For Firbird 3 CPU affinity has no point. > Does upgrading to 3.04 fix that problem or should we use the classic server? In the future, we should install a 64 Bit Windows, but the existing udf-files do not work with this architecture. You must detect where problem is before one can tell for sure whether it will be fixed or not. Start from inspecting MON$MEMORY_USAGE. In any case 3.0.4 has a lot of bugfixes so it is better to upgrade even if it cannot solve your memory problem. -- WBR, SD. ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links