AnsweredAssumed Answered

FMSA 11 implimentation on Windows Server 2008 Standard 64-bit - Memory problem

Question asked by Mike.Ottevaere on Dec 20, 2010
Latest reply on Mar 2, 2011 by Mike.Ottevaere

Summary

FMSA 11 implimentation on Windows Server 2008 Standard 64-bit - Memory problem

Product

FileMaker Server

Version

FileMaker Server Advanced 11.0.2.217

Operating system version

Microsoft© Windows Server© 2008 Standard Version: 6.0.6002 Service Pack 2 Build 6002 - 64 bit version

Description of the issue

Hi,

We notice the following problem/issue with an FMSA 11.0.2.217 implimentation on our dedicated MS Windows Server 2008 Standard edition.
When starting up the FMSA and hosting the FM files (35), the performance monitor of windows shows that about 1.1 Gbyte of the 8 Gb RAM is used.
As users log on to the database, the amount of RAM being used raises gradually.

But what we notice is, that
a) Even when most of the users log out from their connection with the FMSA server, the amount of RAM used never descends anymore;
b) When the backup schedule start, this completely fills the memory, and keeps it that way. And often the FMSA Administration Console no longer refreshes afterwards, and needs to be restarted (The backup schedules run daily)

After some days, the system starts to loose performance, obliging us to try to clear and release memory.

The only way to have the memory cleared, and released, is closing all hosted files and reopen them.

We did already do several maintenance on the database files.

Steps to reproduce the problem

Verify the memory usage on the Performance  Monitor of Microsoft Windows

Expected result

The memory use would be cleared when users logout, or when the backup schedule finishes

Actual result

Memory usage stays at the same level, and continues raising until all is used, and perfoirmance deteriorates.

Configuration information

FileMaker Server Advanced 11.0.2.217
     Max. # FileMaker Pro Connections: 80
     Max. # Files to host: 60
     RAM reserved for Data Cache: 64 Mb
     Cache Flush distribution Interval: 00:01
     PHP & IWP Enabled
     XML, XSLT disabled
     ODBC/JDBC diabled

Currently 35 files in total hosted;
     Largest file size: 2.999,542 Mbyte;


Connections (Averages - Peak)
     Type              | Average | Peak
     CWP               |     1   |   3
     FileMaker Pro     |    51   |  69
     IWP               |     3   |   4

FileMaker Pro Client versions:
     FMP 9, FMP 10

Microsoft© Windows Server© 2008 Standard Version: 6.0.6002 Service Pack 2 Build 6002 - 64 bit version
Processor(s): 1 Processor(s) Installed. [01]: Intel64 Family 6 Model 23 Stepping 10 GenuineIntel ~3000 Mhz
Total Physical Memory: 8.185 MB

Workaround

The only way to have the memory cleared, and released, is closing all hosted files and reopen them.

Outcomes