Solved

refurb server

Posted on 2013-01-27
4
235 Views
Last Modified: 2013-01-31
I am currently running sql server on a hyper v machine.  I was thinking of buying a refurb server to increase the speed.  I was thinking I could get something cheap that would work pretty well.  Can someone please give me advice on what I could get?  I really am not a hardware guy, just a dev.  I want to be able to throw in a lot of memory, large hard drives (that I already have) and that is pretty much it.

Also, can you get a blade server without a rack?  Would a cheap rack be worth it?  It is basically for development and testing.  I am writing  a program to analyze stock trades, so there is a ton of data to churn through.
0
Comment
Question by:jackjohnson44
4 Comments
 
LVL 55

Assisted Solution

by:andyalder
andyalder earned 166 total points
ID: 38824877
You can probably get a second hand Xeon 5500/5600 server fairly cheaply as they are just coming out of 3 year warranty now so they'll be getting replaced just through server refresh program rather than due to being no good. I wouldn't go for an earlier CPU though since 5400 for example takes DDR2 RAM and that old stuff is pretty expensive.

Sounds like you are data mining which is one of the few cases where reliability and redundancy don't matter that much, if a disk fails or a PSU blows then you just run the job again after replacing it. You probably want redundancy for the OS disks and the results but the data you're crunching doesn't matter much if the source is still available later. Perhaps it's small enough data set to fit in RAM, or at least on a small SSD.

For blade server I take it you mean rackmount server, there's no real difference between these and tower models as far as function goes. There will be more rackmount servers on the 2nd hand market simply because they make more, but you can turn a rackmount server into a tower simply by making it a wooden stand. Bear in mind though that the smaller the fans are the louder they are, so 1U and 2U aren't generally suited to a small office.

Workstations aren't that different to tower servers by the way, they may have less redundancy but often run a bit faster for the same price. Generally though you pay a bit more because of the posh graphics.
0
 

Author Comment

by:jackjohnson44
ID: 38825038
Thanks for that response.

My main program I am writing in visual studio and is tiny.  I have a very large amount of data, which I just backup to TB drives.  I am not really worried about anything dying on me.  The data is around 800TB split into a lot of smaller databases.  My main concern is reading and writing to SQL server via a C# winform app.  It's pretty standard read and writes

Do you have any specific recommendations?  I am not looking for the absolute best thing out there, but if I can get something for around $600-$700.
0
 
LVL 30

Assisted Solution

by:pgm554
pgm554 earned 167 total points
ID: 38825599
Look at Craigslist in SanFrancisco
Tons of servers dirt cheap (Dell .HP)
150 200 bucks

http://sfbay.craigslist.org/eby/sys/3575697348.html
0
 
LVL 7

Accepted Solution

by:
D_Vante earned 167 total points
ID: 38827620
you can check geeks.com as well for servers
check http://www.cpubenchmark.net/cpu_list.php for processor speeds
Ent. SAS drives will be the best
More drives the more heads = More IOPs

Something like an HP DL380 with 2 drives for the OS and the rest of the drives for SQL.
15k drives
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Every server (virtual or physical) needs a console: and the console can be provided through hardware directly connected, software for remote connections, local connections, through a KVM, etc. This document explains the different types of consol…
Learn about cloud computing and its benefits for small business owners.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question