ScottPletcher (9/18/2014)
CPU is typically not the bottleneck nowadays, I/O is. More RAM = bigger buffers = less I/O. Thus, RAM will typically be much more vital to performance that CPU speed or bus speed. As the old saying goes, "All computers wait at the same speed".
Ironically, I've just completed a T-SQL fix for a major CPU problem due to some really terrible code that was running 30,000 times during the workday. It was a major bottleneck and it was causing 90% CPU usage for 2 to 5 seconds on an otherwise quiet CPU. When normal daily work entered the picture, all 4 CPUs flattlined at 100% for many seconds just scant seconds apart.
--Jeff Moden
Change is inevitable... Change for the better is not.