This is my first post as I couldn't find any information about this topic.
Problem Summery: FM database hosted by a dedicated FM Advanced Server consumes memory over time and never releases it. There is an auto import (ODBC) from SQL Server a series of tables every day through a FM client, during the process FM Server continues to consume memory until it reaches 99%. After the script completes, FM Server never releases the memory it consumed.
Server Specs (dedicated):
I moved a copy of the database to my local personal PC which has 24 GB of physical RAM and several TB of RAID storage to play around with some larger tasks). Below is a screen shot of performance on my PC running during an update to a calculated field across all the contained tables. Notice the memory section... 99% of my 24 GB is consumed during this process. (FM Pro Advanced 12v3)
Temp solution that I don't like:
Has anyone seen this before? Is there a better way I can handle the memory issue?
Thanks in advance,
what is the server cache set to ? is that 1500 mb ?
even 12% seems high ( 2.8 Gb )
> Cache set to 1500
> One database - 86 GB in size growing by 10 GB per week
> an update to a calculated field across all the contained tables. Notice the memory section... 99% of my 24 GB is consumed