Originally posted by: ribbon13
He said "build" in the OP, and if he wants to buy, I see 5 dual opterons at polywell
Originally posted by: TechBoyJK
I'm lookin for a dual cpu setup with about 4GB of ram, dual sata in a raid1, dual ps, etc..
all for under $2500. I get a 40% transferrable tax credit as well... so if I spend $10K, the state mails me a tax credit for $4000, of which I can sell to a broker for about $3700, cash. I can spend up to $150K and still get 40% back. software is included..... yay!
the rig needs to be able to hand about 25 queries per second @ peak. about 1 million queries per day. each server will have about 2 database files, each having about 10 tables, and each table having about 1million records with about 15 columns of mixed data......
running MS SQL....
I was hoping dual cpu w/ dual core could handle it. I'd like to refrain from stepping up to the price point of quad cpu hardware.... especially since i think i will be working on a per cpu license.
Originally posted by: GuitarDaddy
Dual core CPU's are two physical CPU's, so two dual cores is a quad CPU system and will require four licenses if licensed by CPU I believe. You should be able to build such a system for $4000 or less, and with your tax credit you can probably hit your $2500 budget. The Tyan mobo in ribbons rig is what I would suggest.
I would also suggest going for the cheapest dual core opteron(265) CPU's and upgrading your hard drives to a raid5 SCSII array. With 1mm queries a day harddrive I/O is going to be more important than CPU speed.
Originally posted by: Viditor
Originally posted by: GuitarDaddy
Dual core CPU's are two physical CPU's, so two dual cores is a quad CPU system and will require four licenses if licensed by CPU I believe. You should be able to build such a system for $4000 or less, and with your tax credit you can probably hit your $2500 budget. The Tyan mobo in ribbons rig is what I would suggest.
I would also suggest going for the cheapest dual core opteron(265) CPU's and upgrading your hard drives to a raid5 SCSII array. With 1mm queries a day harddrive I/O is going to be more important than CPU speed.
Microsoft and all major software companies charge per socket, not per core...that's one of the major cost advantages of going multicore on servers.
Edit: Though I think you're quite right about going Raid 5...the extra cost is only about $135...
Originally posted by: ribbon13
I would not use Samsung drives for heavy I/O use, especially if they weren't in RAID5.
Monarch does carry the best drive for the job however, The Western Digital WD4000YR is the sweetest drive I think they have every produced. Review (Be sure to look at page 5)
3 of them in RAID5 would provide 800GB of space and plenty of I/O. If you don't need that much space, get three Western Digital WD740GDs instead, because what your doing is exactly what Raptors were designed for.
Originally posted by: TechBoyJK
either way... im definately going to be building this myself.... if I can save $500, i will definatley do it... id like to pay less than $2500 cash for everything, then get my tax credit...
Originally posted by: GuitarDaddy
Originally posted by: TechBoyJK
either way... im definately going to be building this myself.... if I can save $500, i will definatley do it... id like to pay less than $2500 cash for everything, then get my tax credit...
Don't think you will be able to keep it under $2500 before the tax credit
Just the TYAN motherboard and 2 opteron 265 (the cheapest multi socket dual core) will run around $2000, that only leaves $500 for 4gb ECC ram, harddrives, PS, case, OS, etc.... not gonna happen
ribbon13 that is one wicked machine - Ultra 320 Cheetah 15K.4s' and Dual Opteron 280 + 4GBs' of RAM! Sweet...Originally posted by: ribbon13
My signature workstation is Dual Opteron 280s on a Tyan K8WE