I currently have two separate servers. Both are Windows XP. I need to combine both for ease of use. The first server is running a MySQL database we use internally for an enterprise application. We haven't updated it in a while so it sits on XP.
The other application uses a proprietary system for data storage and is incompatible with anything but Windows XP. I have called to highlight the stupidity of that, but to no avail. They are a world renown company and haven't bothered to update their software yet. I have tried forcing it onto later operating systems and it breaks horribly.
So this new system will have to run Windows XP, which I am not thrilled about. I thought about possibly virtualizing Windows XP but that makes data management and backup a pain and I eventually ruled it out.
So I am trying to assemble hardware for a server. This is a small office with 20 computers that will need to connect to it purely for access to these two services; I am not messing with AD yet, etc. Right now we see a serious lag when all terminals are active on the machine. It is only three or so years old, but buckles under the load. I find this odd, but it does.
I am wondering what the best specs are. I have never purchased a "dedicated" server before. I do want a RAID 1 configuration with 1TB on each drive. Entry level is what we need, though. When it comes to RAM and processor, however, I get lost. I figured I would find a copy of Windows XP x64 somewhere to try and increase the RAM capability.
I am wondering what the specs would be for a good entry level server that could support all of this. Hoping to keep it under $1,000. What is the more important, memory or processor? I realize that it is probably hard to say with the vague description, but as a general rule, would I be better settling for 4gb RAM and a higher processor speed, or taking a lower processor speed and putting more RAM in?