Recently we've upgrade our FMServer from 3 to 5.5.

The system it's running on is a W2000 SP3, 500MHz, 320MB RAM, local RAID5 storage, dual LAN connection.

Hosting 18 db files of together around 250MB for an average 20 users.

Since the upgrade the overall system performance is really bad compared to the old FM3. Most insert and updates now take a couple of seconds where it used to be 'instant'. Sometimes FM even seems to hang for 10-20 seconds before an update is accepted.

We've already played with various settings and monitoring numerous system counters we have notices that the server is 'eating' through it's system cache.

FM is configured with a fixed 20MB cache which results in an avg 97% cache hits. In the taskmanager is shows this a steady 20MB as being used by the FM service. The system cache however is slowly increasing over the day and in a cycle of around 12-15 hours all available system memory is taken by the cache at which point it is suddenly all released, usually performance is bad around the time that the available memory goes to zero.

Has anyone seen this before? Or does anyone have a suggestion on improving performance?

Thanks in advance,

Andries

We never experienced such problem with 100+ users, 123 databases and similar machine.

Only the dual Lan connection is different. Our server was crashing with 2 NIC's. After I thoroughly deinstalled the second one, it didn't crashed in 6 months.

Why you need 2?