Good $5000-$10,000 database server system

[PUPPLESAN]

I need to run an SQL server backend (running on Windows Server 2012) for an approximately 10-user database in a physician's office. The files will include a large number of photographs and scanned images for about 10,000 patients with a 100 patient per day volume with ten users connected and running transactions. Reliability and performance are key. I need mirroring (RAID 1 I suppose). I'd rather avoid building a system but will do so if needed. The hardware budget is about $US 5000-$10,000. Any help is greatly appreciated.

Mark

 

[mrdowntownkiller]

PCPartPicker part list / Price breakdown by merchant / Benchmarks

CPU: Intel Core i7-3970X Extreme Edition 3.5GHz 6-Core Processor ($1079.99 @ Newegg)
CPU Cooler: Noctua NH-D14 SE2011 CPU Cooler ($81.51 @ Amazon)
Motherboard: Gigabyte GA-X79-UD5 EATX LGA2011 Motherboard ($289.99 @ Newegg)
Memory: G.Skill Ripjaws Z Series 32GB (4 x 8GB) DDR3-1866 Memory ($219.99 @ Newegg)
Memory: G.Skill Ripjaws Z Series 32GB (4 x 8GB) DDR3-1866 Memory ($219.99 @ Newegg)
Storage: Samsung 830 Series 512GB 2.5" Solid State Disk ($529.99 @ Newegg)
Storage: Samsung 830 Series 512GB 2.5" Solid State Disk ($529.99 @ Newegg)
Storage: Western Digital WD Black 4TB 3.5" 7200RPM Internal Hard Drive ($326.33 @ Amazon)
Video Card: Asus Radeon HD 7970 GHz Edition 3GB Video Card ($499.99 @ Amazon)
Case: Corsair Obsidian Series 800D ATX Full Tower Case ($249.99 @ Amazon)
Power Supply: XFX ProSeries 1000W 80 PLUS Platinum Certified ATX12V / EPS12V Power Supply ($202.98 @ NCIX US)
Optical Drive: Pioneer BDR-2208 Blu-Ray/DVD/CD Writer ($99.99 @ Newegg)
Operating System: Microsoft Windows 7 Ultimate SP1 (OEM) (64-bit) ($179.99 @ Newegg)
Other: CyberPower Professional PP2200SW 2200VA 1500W 6 NEMA 5-15R, 2 NEMA 5-20R Outlets UPS ($550.99)
Total: $5061.71
(Prices include shipping, taxes, and discounts when available.)
(Generated by PCPartPicker 2012-12-20 07:37 EST-0500)

 

[spentshells]

That could be done with a P4

 

[noidea_77]

I suggest calling you local Dell, IBM and HP sales guy. Local number are on there websites. They have configurations for things like that and deliver support via local partners.

@mrdowntownkiller: an imaging server without ECC ram, but a gaming video card? Never ever!

 

[rgd1101]

i7 3970X for a database server? why? a blu ray? why? and he already have the O/S.
with his requirement it is more I/O bound.

Do what noidea_77 said call your local xxx sales guy.

 

[dingo07]

IBM would be my first choice, Dell second...

 

[bjroth]

HP DL360P Gen8 ~$4700
2x Xeon E5-2640 Six Core
16GB RAM installed
(can be downsized to single proc for a cost of $2600, can still add the second if it become necessary)

6x HP 600GB SFF 10K HDD(RAID 10 for SQL storage, adjust capacity as necessary for your config) This will give you about 1.8TB usable storage
$3,534

2x HP 146GB 15K SAS for OS
$758

Total:
$8,992(dual proc)
$6,892(single proc)

EDIT: The DL380p Gen 8 could be used to add some additional drive bays, the 360p only has 8 while you can add a second 8 bay module to the 380p for a total of 16 bays.

 

[PUPPLESAN]

Best answer selected by PUPPLESAN.

 

[spentshells]

woof