Stuart,
I doubt the OS is the problem in this scenario. As others here point out I have a number of high volume apps running on server 2012 and performance is very fast.
However, you do really have to make sure that nothing else is interfering with your data access. Dmitry mentioned Anti-Virus and if you have that running turn it off and compare performance. AV can have a very dramatic effect on local disk access (even Defender which is 'light' can make a 30% difference). So be sure that you have a clean environment to test perf.
Are you running a VM or physical hardware? If you're running a VM that will be considerably slower than raw metal. Hardware also matters - having fast drives is important.
If all else fails use ProcessMonitor on the machine to check and see what's happening with your disk access - where it's checking for files etc. File lookups can be slow.
And finally just to be sure make sure you reindex and pack all your data to make sure everything is optimized and you're not comparing apples to oranges.
+++ Rick ---
>I am currently testing FoxPro applications on Server 2012R2
>
>I have two scenarios:
>- A single server with applications running on the server and RDP session to that server to run applications
>- Two servers. One server has the applications and data and the other server has a UNC path mapped too the first server. RDP access to the second server is used to run the applications
>
>I am currently experiencing performance issues. General usage of the applications (opening forms, using menus etc) are fine but when data especially large amounts of data is returned things slow down dramatically.
>
>Each of the servers has 4GB memory and 4 cores. These machines are virtual machines.
>
>I would appreciate if anybody has had similar issues and solved them to let me know what you did to solve this.?
>
>Is it a bad option to run the applications over a UNC path?
>
>What would be the optimal memory and core setup be?
>
>Any other info that can point me in the right direction is much appreciated.
