>I assume that the robot is NOT processing the same data as your web application. Correct?
Yes, the robot manages some data that our Web application has to use. So, he has to access the same data.
>If correct, then why can't the data be moved to the same system WITH the SQL Server robot?
There is no SQL Server robot. The robot that is consuming the CPU is a VFP application that is accessing our data.
>What RAM to they have on the server with the problem?
32GB
>Can they upgrade to a multi-processor server?... Depending on what they have now, it could be real cheap or it could mean full replcement.
Is 16 good enough? And, I do not recall having mentioned that this was single CPU. Where did you get that information? :)