>>>Luc,
>>>
>>>I would stop focusing on hardware. You might squeeze a few percent more performance out of it, but you can get much and much more performance gains (up to 10.000% and more) when you look at your application. Identify slow parts and try to tune them.
>>>Are there slow queries? If so, try to rune them by adding or tuning indexes. You might want to redesign queries to run faster.
>>>
>>>Walter,
>>
>>I'm not complaining about the speed of the ERP software. It is running nicely.
>>I was just surprised that after moving the virtual machine from a 5 year old server with less memory to a new server with all the top notch hardware improvement and 64Gig of memory the gain in performance was not that significant.
>>
>>This means that the 4Gig limit was already obtained on the previous server and adding more memory had no effect on the application on the new server.
>
>We've already been over this. I suspect even on the old server, all the significantly used data files were disk-cached in RAM. So with the new server:
>
>- the data files are also cached in RAM
>- CPU performance per core is not a lot better than the old server
>
>So, not surprising the new server isn't much faster than the old one.
>
>If someone's giving you grief because they paid $$$ for a new server and expected more performance gain, well, that's too bad. But facts are facts.
>
>The general consensus seems to be that configuring VFP to use more RAM can be counterproductive. But, your mileage may vary. You could run some tests and let us know.
>
>If you do find some hardware/configuration "secret sauce" that speeds things up significantly, could you let us know?


The new server is also running an Office VM, all users have outlook, excel... installed on it and this one loves RAM.
I think that Foxpro was already at it's limit on the old server and even if I added more ram on the new one there was not much impact.

I will concentrate on IO for the next server. Probably a RAID-10 of PCI SSD...for now they are too expensive.

For sure I'll keep you informed.