I am ready to upgrade the PC that acts as the server and back office PC for a setup running 2 POS lanes and 2 manager PC's that do not run POS. A few years ago it was setup with a XP pro, Pentium 4, 2.8GHz with 1 GB ram. Performance was fine, but now with several years of data, running sales history reports or movement reports is getting very slow. What is the biggest bottleneck for running these reports, hard drive speed, processor speed or memory? I have no problem in the budget for fast hard drives (thinking SAS 15K in a RAID 0) and memory, but how far should I go in upgrading the processor. Is processor speed a big factor in database retrieval/sorting/filtering? Will there be a noticeable difference in performance between a low end quad core or a high end 3 GHz or more processor. Is there any advantage to Xenon processors. I plan on sticking with XP pro and SQL 2005 server, unless convinced otherwise.
Advice / opinions?
Thanks,
Marc