We have 2 Filemaker Pro 13 servers and both have their cache hit % bumping up around 100% most of the time. Both server's FMPS cache setting is set for the server default of 512. When I lower this, as recommended here, and go back to view the stats, it stays at 100%. Is a FMP server reboot required for this change to take effect? I tried lowering it from 512 down to 200 and waited a few mins and the stats didn't change.
Also, the above linked articled mentions, ""Distribute cache flush"", but I don't see this anywhere under Database Server. I only see Database Server > Database Cache.
We have between 50-100 databases on both servers and some total up to 4 GB. I'm trying to maximize performance.