We have been made aware of a Microsoft issue that may have a dramatic impact on 4D Server performance.
The problem is related to the Windows System Cache. In particular Microsoft has acknowledged that the System Cache can be too aggressive in certain versions of Windows.
The danger to 4D applications is that Windows may try to keep the entire datafile in its file system cache and, therefore, will compete with 4D for physical ram.
Here is the KB article from Microsoft describing the problem:
https://support.microsoft.com/kb/976618
The most straightforward way to address this issue is to move to an R2 release of the indicated operating systems. Both Windows Server 2003 and Windows Server 2008 are affected (as well as several other versions, check the Microsoft KB article for details).