HyperThreading and SQL Server 2005
I recently installed SQL Sever 2005 (with SP1) on a server that is P4 3.0 GHz and does hyperthreading. After the installation SQL Server seems to take up 99% of all of the CPU. this was uncanny!
I searched the net and came up with this:
This is Slava Oks's WebLog where he explains whether to do hythreading or not with the SQL Server 2005.