Sign in with
Sign up | Sign in
Your question

Sub $3k SQL Server multi-core development server

Last response: in Systems
Share
April 23, 2011 2:05:41 AM

Approximate Purchase Date: Within 1 month

Budget Range: $3k (soft) Before Rebates

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
=====
$1,796 (sub-total)

CASE: ?
FANS: ?
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)

Overclocking: Maybe

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
24GB Memory
10x 1TB drives to be used in two RAID arrays for SQL Data and Transaction logs
April 23, 2011 2:53:07 AM

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.

-Wolf sends
m
0
l
April 23, 2011 3:43:56 AM

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).
m
0
l
April 23, 2011 7:37:44 PM

Latest parts list, price is climbing

Total $3,692

$ 312 Case: 1x NORCO RPC-4220 4U Rackmount Server Chassis w/ 20 Hot-Swappable SATA/SAS 6G Drive Bays (Mini SAS Connector) - OEM
$ 90 Cables: 7x NORCO C-SFF8087-D SFF-8087 to SFF-8087 Internal Multilane SAS Cable - OEM
$ 430 Motherboard: 1x ASUS KGPE-D16
$ 560 Processor: 2x AMD Opteron 6128 Magny-Cours 2.0GHz 8 x 512KB L2 Cache 12MB L3 Cache Socket G34 115W 8-Core Server Processor
$ 420 Memory: 6x Crucial 4GB 240-Pin DDR3 SDRAM DDR3 1333 (PC3 10600) ECC Unbuffered Server Memory Model CT51272BA1339
$ 160 PSU: 1x SeaSonic X750 Gold 750W ATX12V V2.3/EPS 12V V2.91 SLI Ready 80 PLUS GOLD Certified Modular Active PFC Power Supply
$ 780 Storage: 12x SAMSUNG Spinpoint F3 HD103SJ 1TB 7200 RPM SATA 3.0Gb/s 3.5" Internal Hard Drive -Bare Drive
$ 600 Raid: 1x Areca ARC-1880i PCI-Ex4 8 Port SATA and SAS RAID Card
$ 300 Raid Expander: 1x HP SAS Expander

$ 50 DVD Burner: 1x slim dvd burner (need to find one) + possible StarTech SLSATAF20 20in Slimline SATA Female to SATA with LP4 Power Cable Adapter
m
0
l
!