Just got this email from someone in Ops:

http://news.zdnet.co.uk/0,39020330,39237341,00.htm

http://blogs.msdn.com/slavao/archive/2005/11/12/492119.aspx

Synopsis - Hyperthreading (Intel specific technology) can seriously impedes
performance in SQL and Citrix especially under heavy load.

Is this correct? Any ideas from the SQL peanut gallery here? We only run SQL
clusters, 25-30 of them all on at least dual Xeon's with Hyperthreading.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training

There is no way to make an accurate blanket statement that HT helps or hurts
performance. I have certainly seen it do both depending on the type of
workload. The only way to know for sure is to do extensive testing in your
exact environment with it on and then again with it off.


--
Andrew J. Kelly SQL MVP


"Rodney R. Fournier [MVP]" <rod@die.spam.die.nw-america.com> wrote in
message news:OgI%23x%2337FHA.1020@TK2MSFTNGP15.phx.gbl...
[quoted text, click to view]

I agree with Andrew. The only way to tell if Hyperthreading is good in your environment is do testing. It may be good for
some environments and may not be good for others.

There is a nice blog from Slava Oks on hyperthreading that you may find useful

Be aware: To Hyper or not to Hyper
http://blogs.msdn.com/slavao/archive/2005/11/12/492119.aspx

HTH,

Best Regards,

Uttam Parui
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security
Tool Kit, please visit http://www.microsoft.com/security.

Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against
viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx