Sign in with
Sign up | Sign in
Your question
Solved

Good $5000-$10,000 database server system

Last response: in Systems
Share
December 20, 2012 6:17:03 AM

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
December 20, 2012 10:38:22 AM

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)
m
0
l
December 20, 2012 11:42:21 AM

That could be done with a P4
m
0
l
Related resources
Can't find your answer ? Ask !
December 20, 2012 11:58:33 AM

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!
m
0
l
December 20, 2012 12:07:46 PM

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.
m
0
l
December 20, 2012 12:47:24 PM

IBM would be my first choice, Dell second...
m
0
l

Best solution

December 20, 2012 2:05:14 PM

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.
Share
December 29, 2012 11:58:00 PM

Best answer selected by PUPPLESAN.
m
0
l
!