May 6, 2003 at 11:51 am
Can someone help to find the resource/metrics on comparison in performance and reliability between dual PII 700MHz vs. singular P4 1,8-2,4GHz and dual PIII 550MHz vs. singular P4.
Thanks!
May 9, 2003 at 8:00 am
This was removed by the editor as SPAM
May 9, 2003 at 7:37 pm
a dual 550 or 700 is a fair comparison to a single P4. It would depend on the price. For a little bit more money (around $900) something like dual Tualatin with an ide raid or scsi subsystem on something like a tyan thunder LE (or similar) board would be better.
May 11, 2003 at 8:34 pm
Hi
Even a simple check, like comparing a dual AMD MP2000 with p4 3Ghz sees, most of the time, the dual box leading the way, hyper-threading or not. The key here is the added multi-tasking, run multi-apps etc and of course this is where the difference really shows. The p4 prices are significant, I would consider the p3 (we use 800's with good performance) and lots of kingston or legend ram (2+ Gb).
Of course, scsi raid with 20+mb on the controller is pretty well standard. If you can afford it, scsi-320 and 15k disks
Cheers
Ck
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
May 13, 2003 at 2:19 am
Don't forget the licensing issues!
If your database is serving and internet/extranet/intranet then you will be using per processor licensing hence doubling your costs.
What about single point of failure principles? If your only CPU goes bang then your server is dead. At least a dual processor machine can limp along if one processor is disabled.
May 13, 2003 at 7:52 am
whoops! forgot that one 🙂 and for some sites its a big issue.
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply