October 3, 2013 at 2:58 pm
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
October 4, 2013 at 6:56 am
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[/url]
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
October 4, 2013 at 7:20 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply