RAM versus CPU on SQL 2000 box
Posted on 2004-08-09
We, like everyone, have limited budget for our SQL 7 -> SQL 2000 upgrade.
My problem is that we can buy Standard Edtion for a quad processor box for $20,000 or so. But it can use only 2Gig RAM.
We'd have to pay almost $50,000 for Enterprise Edition for that same box. We could then use more RAM.
What's more important to SQL Server 2000? Memory or CPUs?
Am I faster with:
- quad processor Standard Edition w/ 2Gig memory
- dual processor Enterprise Edition with 8Gig?