Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm currently taking stock of our server before we add a new one. I wasn't involved in its purchase (before my time) but the more I learn about its specifications the more concerned I am. Note: Ultimately it will be used as a Database Server in our new configuration (I don't know if this will change the answer to my question or not).

The server currently has a single dual-core Opteron 2212 (2.0Ghz). The problem is that while I've been investigating this processor, I've come across statements like this one: "Dual- and quad-socket set-ups are a must with this chip... It would be pointless to only use one."

Plus, all the benchmarks I've seen for this CPU only show a two-socket configuration.

For example: CPUBenchmarks.net

In fact, I can't even find any benchmarks for the single CPU... everything lists it in a two-socket set-up.

Did we do something wrong here? Should this chip always be used in a dual-socket configuration? If so, why? What's so bad about having only one? And why did Dell allow us to buy a PowerEdge SC1435 from them with only chip installed?

I'm really confused why so many places would seemingly list this as an issue.

share|improve this question
1  
Your quote seems to be from a buyer on newegg that is using it for video editing. Video guys are typically just power hungry, hardware junkies. –  ITGuy24 Nov 5 '09 at 18:18
    
I would be far more concerned about the single power supply, and whether the system has the optional raid controller or not. Dell's SC series is for applications where some downtime is an acceptable tradeoff for the lower initial price, for example in server farms with higher level redundancy, or very small businesses that are not overly computer dependent. You have to consider whether that is the system you really want to be your database server. –  kmarsh Feb 25 '10 at 14:40

4 Answers 4

up vote 1 down vote accepted

Did we do something wrong here?

No, you did nothing wrong. If servers can be upgraded, then adding a second CPU is simply a feature that you have not exercised. Who cares what other people say? If the system is running fine without any issues, if anything you've saved yourself a few bucks and a little bit on the electric bill. You should be praised assuming that your servers don't need the extra CPU and everything is running smoothly.

Should this chip always be used in a dual-socket configuration?

All CPUs can be used in anyway they're designed to. If you have just one in place and it works fine, don't sweat it. Both Xeons and Opterons are built for this.

What's so bad about having only one?

Absolutely nothing. I ran 3 servers for a small office of about 30-40 users all running just one Opteron CPU each. I didn't need to get dual CPUs for each server. The load wasn't that much so why spend more $$$ and consume more electricity when it's not needed.

And why did Dell allow us to buy a PowerEdge SC1435 from them with only chip installed?

Rule #1 in business: if logic/reason cannot explain things, it always comes down to money. Actually, in Dell's case, it's always good to offer consumers options. Granted too many options and we become unhappy as they're are too many permutations of purchasing just one thing. This book explains why.

I'm really confused why so many places would seemingly list this as an issue.

Unless you're running a huge database cluster and need every single ounce of CPU horsepower for ETL, CRM or what have you, there's really no negative points on running a single CPU if that's what's needed. If applications, file servers, email, whatever are all running smoothly and capacity is not an issue, what's the point of adding more muscle when it may not be fully utilized?

Now, if you're looking to vendors for advise on running things, then you're simply getting the sales pitch. Always be weary of the source of information and their goals.

In fact, I'm going to go out on a limb to say simply don't listen, believe or give credit to others when they don't supply any real reason, logic or some explanation as to why they believe what they believe. This rule can be applied anywhere so don't fret on what people advise or say without any reasoning. No reasoning or logic, just dismiss it as noise.

I've run Opteron systems for work and at home. As CPUs they're great as they're usually cheaper then their Xeon counterparts and usually use less electricity. In my eyes, adding another CPU to a system "just because" it would be silly not to is poor logic. Poor logic is never good reason to do (or not do) something. You're doing just fine in questioning this line of thinking. All you need is the confidence to follow through on your logic/reasoning.

share|improve this answer
    
Well I trust my own reasoning, but if others are saying something because they understand more than me, then my reasoning becomes faulty until I understand why they're saying what they're saying. Thanks for your answer! –  Django Reinhardt Nov 5 '09 at 18:43
    
"usually use less electricity" ... I would usually disagree, but with the newest opterons it might be different. The 2212 btw is ancient, and I would expect a brutal power usage from it even when idle. And power becomes an important argument in the 1 or 2 socket debate. IF 1 box with 2 sockets can replace 2 boxes with 1 socket, power usage will usually be lower especially if 2 boxes are designed with 2 sockets and have one unpopulated; you will probably be running the PSUs far off their design operating point. –  rackandboneman May 11 '12 at 17:54
    
"they're usually cheaper then their Xeon counterparts and usually use less electricity". Everything is relative. You have to compare the 2212 to whatever Xeons were available at the time. It's pointless to compare older CPUs to newer ones, especially when it comes to power usage. Opteron 2212 was released in August of 2006 at 95W TDP. Many of the Opterons were between the 68W-95W range, with one model at 45W. Most of the Xeons at the time were in the 95w-150w with the exception of the ULV/LV (ultra/low-voltage) CPUs in the 15w-31w range. All-in-all, AMD had the edge at the time. –  osij2is May 14 '12 at 16:53

One other thing to bring up: If you are going to use it as a database server, you will want to gauge how long your average query is going to be. If you get two long running queries, your database server is going to become unresponsive to the third query (even if it is just a simple single record request). We made this mistake on a database server and the users very quickly became very unhappy. Especially if you are using Stored Procedures with RBAR in them...
After about a week, I placed an order for another dual core chip to fill the second socket. Our database runs our accounting package, which frequently runs queries that feed reports. Some of these queries hit tables with millions of records in them and take 15-30 seconds to run. If your load is different, you might be able to get away with one dual-core socket.

share|improve this answer
    
+1 Our SQL guy tells me he would never write such sloppy RBAR code... so I guess we're OK on that front :) If we're still maxing out then I guess we have the option to upgrade the hardware. Thanks. –  Django Reinhardt Nov 6 '09 at 12:16

I'm a big fan of your work ;-)

I just took a look at this spec sheet, and it looks like your box can only handle two sockets max. I would guess that it having two cores is perfectly appropriate.

The only reason to think it is underpowered is if it just doesn't hold up in production. We use dual core boxes all the time.

share|improve this answer
    
Thanks very much! ;^) Thanks for the link, too! –  Django Reinhardt Nov 5 '09 at 17:41

One of the things to consider is the cost from a price/performance ratio. Very often you can get dual processor AMD machines cheaper than the single processor version (and/or the price/performance cost cost down due to the opteron fabric). the price/performance ratio goes up primarily because adding an additional Opteron processor increases memory bandwidth to all processors. In addition, one of the reasons that the Opterons are almost exclusively sold as multi-socket configs is that the selling point for the operton was the fact that it scales multi-processor far better than the xeon equivalent. As far as I know, however, the nehalem architecture removes the issue from the intel side.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.