sql server build

M

mobgrazer

New Member
I'm building a new SQL server and looking for a bit of help. I;m looking at a max of 5 users but the size has out grown access a long time ago. I will be running Windows 008 64 bit and SQL Server 2008 Express.
The most important thing about the build is stability.


Antec 4U22EPS650 4U Rackmount Server Case 650W 6 External 5.25" Drive Bays
http://www.newegg.com/Product/Product.aspx?Item=N82E16811129049

System files Western Digital Caviar Black WD2002FAEX 2TB 7200 RPM 64MB Cache SATA 6.0Gb/s
http://www.newegg.com/Product/Product.aspx?Item=N82E16822136792

3x Western Digital VelociRaptor WD4500HLHX 450GB 10000 RPM 32MB Cache SATA 6.0Gb/s 3.5"
http://www.newegg.com/Product/Product.aspx?Item=N82E16822136557

backup Western Digital Caviar Black WD1501FASS 1.5TB 7200 RPM 64MB Cache SATA 2
http://www.newegg.com/Product/Product.aspx?Item=N82E16822136592

COOLER MASTER STB-3T4-E3-GP 4-in-3 Device Module Hardisk Cage
http://www.newegg.com/Product/Product.aspx?Item=N82E16817993002

ASUS P8Z68-V PRO LGA 1155 Intel Z68 HDMI SATA 6Gb/s USB 3.0 ATX
http://www.newegg.com/Product/Product.aspx?Item=N82E16813131730

Intel Core i5-2300 Sandy Bridge 2.8GHz (3.1GHz Turbo Boost) 4 x 256KB L2 Cache 6MB L3 Cache LGA 1155 95W
http://www.newegg.com/Product/Product.aspx?Item=N82E16819115076

4x Kingston HyperX 4GB 240-Pin DDR3 SDRAM DDR3 1600
http://www.newegg.com/Product/Product.aspx?Item=N82E16820104244


What power supply would you recommend?
Do you see any stability issues?
 
D

dsgarcia

New Member
That 650W PSU that is included will run great for you. With all the drives that you are wanting to run I think you should be fine on a 600W. Do you realize the motherboard you selected has no on board video? You will have to purchase a video card for this server if you use the parts you selected. Other then that I think everything looks good. I would strongly recommend selected a motherboard with integrated video its way more cost effective. Another thing to consider is the fact that the amount of drives you have selected is total overkill. I have set up a few servers in my time and even with 20 users you wouldn't utilize all of the speed of your storage assuming that your are using raid 5 for redundancy.
 
Last edited:
M

mobgrazer

New Member
I thought that motherboard had on board video with the dvi and vga port. But your right it dose say no video. I do like the motherboard but that is something to think about. I was thinking about a different power supply thinking about quality. With SQL it's better to split it between drives.


If there were more users or would be running more programs then I would go with an Xeon.


The Asus web site syas it has on board video.
http://www.asus.com/Motherboards/Intel_Socket_1155/P8Z68V_PRO/#specifications
 
Last edited:
jonnyp11

jonnyp11

New Member
nope, the mobo doesn't, but the i5 has a gpu on its die so that's where the video comes from :p And the psu in there is fine cuz it's an antec case it's an antec psu and they make good ones so you're fine there.
 
D

dsgarcia

New Member
jonnyp11 said:
i'd say to aim for something more like this, they are made for handling more tasks at the same time and some other stuff like that, idk really but i know server cpus run servers better, otherwise they wouldn't make them. Otherwise a 2500k is worth it so you can overclock it and get the server faster.

http://www.newegg.com/Product/Product.aspx?Item=N82E16819115084
Click to expand...

Jonnyp11 he is wanting to have a STABLE server he doesn't want to overclock.... This is a server that is going to be handling a load of 5 users so in all reality any dual core could handle this task! He doesn't need to spend more money on his CPU at all the CPU he has selected is more then enough to handle a load of 50+ users. I would highly recommend getting a board with integrated video. Antec is a really good brand I would stay with the PSU already in the case it will be high quality for sure. BTW I have a SQL server on a dual core machine with more then 30 active connections at one time and it works like magic very fast! SQL is not very processor intensive unless your planning on using it as a web data instance then your going to need a xeon
 
Last edited:
M

mobgrazer

New Member
I have not found another motherboard I like. I like Intel more than AMD and I like Ausu and Gigabyte. I'll do more looking tomorrow.
 
jonnyp11

jonnyp11

New Member
like i said, the graphics are on the cpu, look on its page, the mobo has no need for them since the cpu has some pretty dang good ones on it. and also gigabyte is considered a little higher quality/better support lately and also ASRock is a great brand too.
 
M

mobgrazer

New Member
After doing a ton of reading and searching my gut feeling is an AMD with a ASRock motherboard.
Thank you jonnpy11 for sugesting ASRock.

ASRock 890GX PRO3 AM3+ AMD 890GX HDMI SATA 6Gb/s USB 3.0 ATX AMD Motherboard
http://www.newegg.com/Product/Product.aspx?Item=N82E16813157244

2 X Kingston 8GB (2 x 4GB) 240-Pin DDR3 SDRAM DDR3 1333 (PC3 10600)
http://www.newegg.com/Product/Product.aspx?Item=N82E16820139075

AMD Phenom II X4 965 Black Edition Deneb 3.4GHz 4 x 512KB L2 Cache 6MB L3 Cache
http://www.newegg.com/Product/Product.aspx?Item=N82E16819103727


I'm still thinking the same case, hard drive cage, and part of the hard drives (found a great article on hard drive setup with SQL.
 
You must log in or register to reply here.
Top