I want to upgrade my CPU so that I have a computer that is comfortably capable of handling a Website that relies heavily on SQL Server database activities. Lots of CRUD activities I guess you could say. So I've been looking at CPUs and there are so many
different ones available now Im not sure which is the best. I would like to understand how multiple cores address multiple requests on a web server.
Right now I have a Pentium Dual-Core Wolfdale E6300 @ 2.8GHz. At what number of user activity per hour would I need to consider going from a dual-core to a quad-core or even a six-core CPU? Is there a good formula. Something along the lines of:
Dual-Core good for 5,000 simultaneous requests per/hour
Quad-Core needed for 5,000-25,000 simultaneous requests/hour
I just have no idea where I stand right now with a Pentium Dual-Core E6300. Is it a no brainer just to buy a six-core if its going to be used exclusively for a web server? I would like to purchase a six-core if it will always produce the best results but
I hate to upgrade too fast unnecessarily. If a dual-core is good for say, up to 10,000 requests per hour, then I could safely upgrade further down the road as my website grows. Looking for some good knowledgeable input from those with more experience on this
matter. Thanks.
System configuration: Windows 7 RTM, Gigabyte GA-EP45-UD3L motherboard, Intel Pentium Dual-Core E6300 Wolfdale @ 2.8GHz, 4GB PC-1066 DDR2 Patriot Viper Memory, 500 GB Western Digital Hard Disk, "GeForce 8800GT" videocard