System Usage from Most to Least Important: SQL Server 2008 Development Server
Parts Not Required: keyboard, mouse, monitor, speakers, OS
Preferred Website(s) for Parts: newegg.com, but open to others
Country of Origin: U.S.A.
Parts Preferences: This is what I have spec'd out so far
$430 Mobo: ASUS KGPE-D16
$560 Proc: 2x AMD Opteron 6128 Magny-Cours 2.0GHz 8 x 512KB L2 Cache 12MB L3 Cache Socket G34 115W 8-Core Server Processor
$234 Memory: 6x Patriot Signature 4GB 240-Pin DDR3 SDRAM DDR3 1333 (PC3 10600) Desktop Memory Model PSD34G13332
$550 Disk: 10x SAMSUNG Spinpoint F3 HD103SJ 1TB 7200 RPM 32MB Cache SATA 3.0Gb/s 3.5" Internal Hard Drive -Bare Drive
$22 CD Drive: ASUS DRW-24B1ST/BLK/B/AS
SSD: 2x ? to be used for OS + SQL (Windows Server 2008 + SQL Server 2008)
PSU: ? what do I need? 500 or 750W?
GPU: ? not a gaming rig, I assume anything basic with DVI or HDMI output, would like display port since I have a 30" monitor available but when I looked it was only gaming cards which I do not think I need/want in this system
RAID 1 Controller: ? (for two SSD drives for OS)
RAID 10 Controller: ? (for four 1TB HDD for transaction log)
RAID 5 Controller: ? (for five 1TB HDD for data + maybe 1 for hot spare)
SLI or Crossfire: No
Monitor Resolution: 1920x1080
Additional Comments: I do not know much about Raid controllers, seems like a lot to choose from. Someone at hardforum suggested a used Dell Perc 5/i for the 4 disk RAID 10 and the 5 disk RAID 5 - can that 1 card handle both duties? I also would like the OS to be in RAID, what is the minimum size disk I can get away with for Windows 2008 R2 Server + SQL Server 2008 R2, 100GB I am guessing should be fine? Was looking at possibly two SSD's in RAID 1 for the OS + SQL. Also is it ok to put the 10 1TB drives in a case or should I look for external storage?
16-cores @ 2.0MHz
10x 1TB drives to be used in two RAID arrays for SQL Data and Transaction logs
Any particular reason you're going with such overkill? Microsoft's System Requirements for SQL Server 2008 at worst calls for a single-core 2.0 GHz processor (even a P4) and four GB of RAM. I mean, if you're running eight instances of SQL Server 2008 simultaneously, then I could see it, but if not...
The system I have listed in my signature runs both SQL server and IIS without a hitch. Unless you have a specific reason for such a high powered system, you could probably save yourself $1000.
I am working on algorithmic trading patterns, tracking about 50 different financial instruments, 8 different chart intervals per instrument on tick data going back 10 years. The processors are pretty cheap anyway, $560 for 16 cores is a steal, for comparison sake, a 1 month lease in the cloud is $900 for 34GB of ram + 13 EC2 Compute Units (4 virtual cores with 3.25 EC2 Compute Units each).