Archive 1997–2024

The Opteron 6276: a closer look

MS SQL Server 2008 Power Analysis

We'll let power consumption be the final judge:

Concurrency CMT No CMT Power Increase
CMT vs. No CMT
HTT No HTT Power Increase
HTT vs. No HTT
25 144 141 2% 159 156 2%
40 156 160 -2% 169 163 4%
80 185 194 -5% 182 174 4%
100 211 209 1% 192 177 8%
125 223 224 0% 201 186 8%
200 250 254 -2% 235 213 10%
300 290 283 3% 277 251 10%
350 305 288 6% 299 275 9%
400 316 288 10% 303 275 10%
500 316 291 9% 314 275 14%
600 324 299 9% 312 285 9%
800 324 308 5% 320 289 11%

CMT increases the amount of power consumed by 6-10%, but only at high loads. The extra clusters probably allow the modules (as AMD likes to call the cores) to sleep more frequently at lighter loads, and we measure no increase or even a small decrease in power consumption. The message is clear: there is no reason to disable CMT when running MS SQL Server.

Hyper-Threading seems to increase the power dissipation always. At higher concurrencies, the higher performance must be paid with a 10-14% power increase, so you might consider disabling Hyper-Threading if your want to cap maximum power output for some reason (e.g. getting to close to the maximum amount of amps allowed in your rack).

MS SQL Server OLAP Conclusion

We invested 10 times more time in our MS SQL Server testing, but frankly we are glad we did. The Opteron 6174 seems to be a true champion from a simple "throughput/power at 100%" analysis, but the reality is that servers hardly ever run at such loads. Under light loads, the Opteron 6174 is either slower and consumes more power (Balanced power setting) or it consumes quite a bit more (High Performance power setting) while being roughly on par with the competition in terms of performance. At medium load, the Opterons are beaten solidly by the Xeon; the Xeon consumes quite a bit less power in "Balanced" and performs a lot better (response times).

At the end of the day, the Xeon X5650 is the better chip (especially in "Balanced" mode) but it's also the more expensive one. The Opteron 6276 price/performance/watt ratio remains quite attractive, but if pricing is taken into account everything will depend on which MS SQL Server License you will get. We will leave that analysis to other people as an economic analysis of complex, customer unfriendly licensing is definitely out of the scope of this article.

Originally published at https://www.anandtech.com/show/5279/the-opteron-6276-a-closer-look (Wayback Machine).