Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


AMD processor issue


AMD processor issue

Author
Message
PiMané
PiMané
Mr or Mrs. 500
Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)

Group: General Forum Members
Points: 592 Visits: 1334
Hi,

I read somewhere, don't recall if it was here or some other forum or blog, that AMD Opteron processors should have hyper-threading disabled in order for SQL Server 2008 R2 use it's "full power", since hyper-threading could "mistake" the engine...
Is it true or has the problem been fixed? The R2 version is RTM and the CPU is Opteron 2435.

Thanks,
Pedro



If you need to work better, try working less...
Jason Carter
Jason Carter
Grasshopper
Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)

Group: General Forum Members
Points: 23 Visits: 277
Are you talking about the Windows Power Plan settings? If so check these out.

http://sqlserverperformance.wordpress.com/2010/09/28/windows-power-plans-and-cpu-performance

http://www.brentozar.com/archive/2010/10/sql-server-on-powersaving-cpus-not-so-fast

http://greg.blogs.sqlsentry.net/2011/01/ensuring-maximum-cpu-performance-via.html

Jason Carter
Tampa, Florida

"Anyone who stops learning is old, whether at twenty or eighty. Anyone who keeps learning stays young. The greatest thing in life is to keep your mind young" - Henry Ford
PiMané
PiMané
Mr or Mrs. 500
Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)

Group: General Forum Members
Points: 592 Visits: 1334
Not quite...
From what I recall from the article someone had the CPU HT active on the BIOS and SQL was "fooled" to think it had more cores that actually had, so MAXDOP with 0 (auto) was launching more threads than the CPU actually supported... But this only happened with AMD CPUs...
Don't know if a SP for 2008 R2 already fix the problem or if this is the problem (don't remember well)...

Pedro



If you need to work better, try working less...
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search