Dual Opterons vs. Dual Xeons in SQL

[Glavinsolo]

SQL does per processor licensing. Xeons have HT enabled. So I have 3 options

2 Opterons = 2 processors
2 Xeons = 4 processors
2 Xeons HT disabled = 2 processors

Can someone post in a reply actual performance graphs of all three of these setups?

With SQL as a benchmark.

A link would also be nice but it may be blocked.

Thanks

 

[jose]

Opteron vs Xeon links:

http://www.linuxhardware.org/a...204232&mode=thread

http://www6.tomshardware.com/cpu/20040927/index.html

Note that the Xeons are on a shared bus, both processors use the same memory bus, that why Xeons don't scale well. ie dual xeons use 1/2 the bus , while quad xeons use 1/4 the bus.

My recomendation is get dual or quad opterons with 2-4gigs of memory for each processor depending on your budget.

Regards,
Jose

 

[Markfw]

How about This Anandtech bench of Opteron 250's VS the NEW 3.6 noconas ? They really kick a$$. The noconas can;t compete in server stuff due to their handicapped memory bandwidth compared to the opterons.

 

[DAPUNISHER]

The Opteron is tough in MySQL Most the server side performance stuff I've read, especially in 64bit seems to favor Opteron.

 

[Bateluer]

SQL charges fees per processor, even if that 'processor' is a logical processor from HT? Thats kinda fvcked up.

 

[FlameDeer]

For sure, 2 Opterons is the Choice! :beer:😀

 

[Mik3y]

hyperthreading doesnt make a cpu act as 2 processors. it only allows for better multi-tasking, but is no where near dual cpu's.

 

[sonoran]

Originally posted by: Glavinsolo
SQL does per processor licensing. Xeons have HT enabled.

I'm pretty sure a hyperthreaded CPU is considered a "single" CPU for SQL Server licensing purposes. In fact, didn't Microsoft recently announce that they would even consider the pending dual-core chips "single" CPU's for licensing purposes?

 

[bofkentucky]

You are correct Sonoran MS SQL is going to be a one package=1cpu deal, at least for now. That being said, the poster didn't say which commercial SQl server he was using.

 

[klah]

http://www.anandtech.com/IT/showdoc.aspx?i=2291

Dual CPU Database Server Comparison
December 2nd, 2004

The Opteron deals out a decisive blow to the Xeons in MySQL. We know from past experiences that when you run extremely complicated SQL statements, the Opterons were a lot faster. After this project, we also know that the Opteron is still the winner when you mix a lot of simple queries with a few heavier queries.