I am running FM Server 9 on a Dual 2.0 Xeon Win2003 R2 server with 4GB of RAM. I have a script that seems to be losing records. It was not doing this when server was 8.04. It looks as though the FM Pro clients are processing the script faster than the server can handle it (even on slower PCs), because by adding a simple 2 second pause or a flush cache to disc to the script corrects the problem.

The issue is that now the head of research says he can't trust any of our hundreds of scripts until the flush cache part is added to each script. Has anyone else been having issues with Filemaker Server 9 performance lagging way behind Filemaker Pro?

Well, flush cache to disk is a client side operation, not a server side operation. That step does not flush the server cache.

How much RAM of that 4 GB do you have assigned to cache on the server and what is teh flush interval?

Steven