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
More about :sql server multi core development server
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).