SQL Server Performance Forum – Threads Archive

SQL Server 2005 Setup

We are about to convert to SQL Server 2005 EE on a new server machine. The question came up about hyper-threading and how it can affect performance. From what I have seen hyper-threading should be turned off until you specifically see the CPU usage too high for a specific CPU. Does this sound correct?
Also, are there any specific "gotchas" that anyone has seen from 2005 or recommendations that can be made other than what can be found in the standard documentation be fore I start the conversion setup and testing?
Thanks. (moved from SQL2k forum)

Check:
http://blogs.msdn.com/slavao/archive/2005/11/12/492119.aspx Luis Martin
Moderator
SQL-Server-Performance.com Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
Leonardo Da Vinci Nunca esperes el reconocimiento de tus hijos, eso ocurrirÃ¡ luego de tu muerte
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Exactly what I was looking for, Thanks Luis

]]>