I am attempting to replace our current DB server with something faster. Most of my (hoped for) speed gains will be from going to a high-end RAID card instead of the current "Windows Mirror" approach. However, I would like to increase the CPU horsepower as well.
My limiting factor is that the DB (Sybase SQL Anywhere 5.5) does not utilize multiple processors. The current server has a 3.6 GHz Xeon processor. My understanding is that replacing that with, say, a dual core 2.4 GHz processor would end up being a downgrade (for my particular situation) because the DB would only use a single core. Is that correct? If so, what are the fastest single core cpu's out there? I found the 3.6 GHz Xeon for about $800 so I know they won't be cheap...