New sql Xeon Server Build

Toggle sidebar Toggle sidebar
maxinexus

maxinexus

Distinguished
Jan 1, 2007
1,101
1
19,360
Hello,
I have lot of exp with building gaming rigs but this will be my first server. I'd like to build a new xeon server for my office. Budget $2-4k. I have 15 PC that are currently connected to my old server. I don't plan on adding any new PC.
Thanks
 
Solution
hdeezie80
Your going to want to put most of the focus on IO for a mySQL server RAM/HDDs/Network, you generally want a seperate machine optimized for each task you need done. If your planning on running a single machine than your server needs to be built for virtualization. It's also a lot easier to design the hardware since your going for all computing power, you will also be utilizing the entire system if you implement it correctly.

I came up with this list of hardware for virtualizing a web server, mySQL server, and application server. I assume you will be running linux as the OS and reusing network cards from the old server.

You won't actually need or really want a video card in your system, the board I suggested in the list below comes...
Sort by date Sort by votes
Jim_L9

Jim_L9

Distinguished
Mar 10, 2006
1,183
0
19,360
You can certainly build a server for this, but for critical apps like a DB server I like to use hardware and drivers that are supported by a manufacturer. You can get a support contract where the server provider can get replacement hardware to you quickly. With only 15 clients connected I think a DB server in a virtualized environment makes a lot of sense. Will the server only be for MS SQL?
 
Upvote 0 Downvote
Jim_L9

Jim_L9

Distinguished
Mar 10, 2006
1,183
0
19,360
I would look into this more. It is hard to recommend a server to build or purchase without knowing what it is doing. Does it do email (Exchange), MS SQL, file sharing and/or other things? What are the specs for the current server? How important is redundancy, high availability and recovery?
 
Upvote 0 Downvote
mi1ez

mi1ez

Splendid
Jul 17, 2007
4,771
1
23,160
Straight off the bat I would say look at making sure you run at least RAID5 for a balance redundancy and capacity, or RAID 6 for more redundancy. For a database you're probably wanting to look at 15k drives.

Get a decent UPS - I've never worked anywhere that doesn't use APC for a single server, or in bigger environments switches protected by APC.

How often will database requests be made? How many concurrent requests are likely? What other infrastructure do you have?
 
Upvote 0 Downvote
maxinexus

maxinexus

Distinguished
Jan 1, 2007
1,101
1
19,360


From newegg:
This is what I come up with:
Intel Xeon E5-2620 Sandy Bridge-EP 2.0GHz (2.5GHz Turbo Boost) LGA 2011 95W Six-Core Server Processor
SUPERMICRO X9SRE-3F ATX Server Motherboard LGA 2011 DDR3 1600/1333/1066
Kingston 32GB (4 x 8GB) 240-Pin DDR3 SDRAM DDR3 1600 ECC Registered Server Memory DR x4 Intel Model
(OS)SAMSUNG 840 Pro Series MZ-7PD256BW 2.5" 256GB SATA III MLC Internal Solid State Drive (SSD)
(RAID5) 3xWestern Digital WD VelociRaptor 500GB 10000 RPM SATA 6.0Gb/s 3.5" Internal Hard Drive -Bare Drive - OEM
MSI N660 TF 2GD5/OC GeForce GTX 660 2GB 192-bit GDDR5 PCI Express 3.0 x16 HDCP Ready SLI Support Video Card
Athena Power AP-RRP4ATX6508 80 PLUS Certified 20+4Pin 2 x 500W Mini Redundant Server Power Supply - OEM
IN WIN Dragon Rider Black 1.0 - 0.8mm SECC Steel ATX Full Tower Computer Case
APC Smart-UPS XL 1000VA USB & Serial 120V

Total is almost $2500

Will 500W PSU be enough?

 
Upvote 0 Downvote
hdeezie80

hdeezie80

Honorable
Jul 18, 2012
205
0
10,710
Your going to want to put most of the focus on IO for a mySQL server RAM/HDDs/Network, you generally want a seperate machine optimized for each task you need done. If your planning on running a single machine than your server needs to be built for virtualization. It's also a lot easier to design the hardware since your going for all computing power, you will also be utilizing the entire system if you implement it correctly.

I came up with this list of hardware for virtualizing a web server, mySQL server, and application server. I assume you will be running linux as the OS and reusing network cards from the old server.

You won't actually need or really want a video card in your system, the board I suggested in the list below comes with integrated graphics built onto the board. Also the velociraptors are not the wisest choice for a server chasis, due to heat/ fail rate. Stick with SAS drives if your going 10k or higher RPM.

Motherboard -> $421 SuperMicro X9DRW-3F - integrated graphics, 2p for optimal virtualization allows installation of up to 512GB of registered ram, and has 6 sata ports and 8 SAS ports onboard SAS is capable of raid 5

CPU -> $1268 -> $634 per CPU x 2 = $1268 xeon e5-2630 -> support everything needed

RAM -> $520 64GB 8X16GB RAM Memory for SuperMicro X9 Series 1333 MHz -> 4GB for the host 32GB for the

HDDS -> $170 x 4 = 680 SAS CHEETAH 15k 450GB 4 would b to make a raid 5 array when micron m500 980GB ssds become available I would recommend using 3 for a secondary raid 5 array to handle the bulk of IO these will still be good for sequential writes but you will need to configure the OS to handle this

SSD -> $490 Intel 320 Series 300 GB -> for the host system boot drive, can be partitioned for SSD caching, and VM OSes

CHASSIS -> $426 SuperChassis 113TQ-600W -> PSU included

COOLER -> $70 -> $35 per cooler x 2 dynatron 1u active cooler

TOTAL $3995

If you can put up more details on about your current setup and what the intent of the build is and the level of use of your current build it would be easier to suggest an effective longterm build this time.
 
Upvote 0 Downvote
Solution
You must log in or register to reply here.

TRENDING THREADS

Latest posts

Moderators online

Share this page

COMPANY
RESOURCES
FOLLOW
Top Bottom