Sign in with
Sign up | Sign in
Your question
Solved

New sql Xeon Server Build

Tags:
Last response: in Systems
Share
April 18, 2013 5:43:08 AM

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

More about : sql xeon server build

April 18, 2013 5:48:38 AM

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?
m
0
l
April 18, 2013 6:05:45 AM

Are you after a server to just host your SQL database or are you looking at a full domain environment?
m
0
l
Related resources
April 18, 2013 7:30:34 AM

I'm new in this so I think SQL/DB server
m
0
l
April 18, 2013 8:20:31 AM

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?
m
0
l
April 19, 2013 1:17:33 AM

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?
m
0
l
April 19, 2013 8:14:34 AM

mi1ez said:
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?


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?

m
0
l

Best solution

April 21, 2013 3:55:23 AM

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.
Share
!