The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.
Building a Xeon Rack Server
Lanthis
Registered User regular
Registered User regular
I'm looking into building (or buying) a new database server for work.
We're looking at:
1 Clovertown Xeon 2.3ghz
16GB (2x8)
a rack server chassis with redundant power supply
Can anyone give me advice/recommendations/links?
We're going to set up a RAID of HD's... what kind of RAID is best for low user-high data size operations on an SQL server database? The database is around 200gb.
I'm pretty new to all of this, and this is a big step up in job responsibility so I want to learn as much as possible and make the right choice/be able to take charge, because eventually I'll probably be backup-administrating our other servers... so if anyone has any further recommendations/advice on that, or what to read, etc, it would be much appreciated.
We're looking at:
1 Clovertown Xeon 2.3ghz
16GB (2x8)
a rack server chassis with redundant power supply
Can anyone give me advice/recommendations/links?
We're going to set up a RAID of HD's... what kind of RAID is best for low user-high data size operations on an SQL server database? The database is around 200gb.
I'm pretty new to all of this, and this is a big step up in job responsibility so I want to learn as much as possible and make the right choice/be able to take charge, because eventually I'll probably be backup-administrating our other servers... so if anyone has any further recommendations/advice on that, or what to read, etc, it would be much appreciated.
Lanthis on
0
Posts
We run an ML-330 G4 (4th generation) for our database which is about 1/10 the size of yours.
Drive wise, I usually go with a Mirrored pair of small drives (36 or 73GB U320 SCSI) for the OS partition, 3 more for a RAID5 for the mdf, plus 1 as a hot spare. They also say you should keep your ldf and mdf on seperate RAID arrays.
SQL supposedly gets its best performance on a RAID10, but they can get real expensive real fast (you need a shitton of physical disks).
so basically in yours you could go
2x 73GB = C: (73GB)
3x 146GB =
1x 146GB hotspare
The model from HP i'd probably look at is the Proliant DL380 G4. I'm not sure if it has dual Powersupplies though.
If you're looking to really save money, you could build your own, I've used SuperMicro systems before, This one looks about what you'd need, but you still need to find someone who sells them and buy the CPUs, RAM, and drives as well.
For a business, I would definitely recommend getting a prebuilt server like an HP or Dell. Having a real warranty with an SLA for getting spare parts to you is a lifesaver. Also, I've never seen a good DIY equivalent of an integrated lights-out board. Those are a lifesaver too.
http://www.thelostworlds.net/
And no, dude, you don't have to buy jack shit from me, this is a professional courtesy between IT folks. Besides, Friday's are pretty slow anyway.
We've already got the drives, and we selected a Supermicro chassis and we're getting the RAM/Proc from Newegg... I'll post final stats and stuff after we order it, but in the end I think we're saving well over 2K for a similarly priced setup from Dell or HP.
Make sure that your shit is brand new; if there's one thing that online stores love to do, it's hand out an open box item. Oh, yeah, double check your physical conifgs are good too; I had a customer who had to RMA $12,000 in RAM and he's dragging his feet on it. My company is fairly lenient about it, but most aren't unless they're at the enterprise level.
If you need anything, doggie, hit it up with a PM over the weekend and I'll shoot you an e-mail at work.