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:

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

This is Slava Oks's WebLog where he explains whether to do hythreading or not with the SQL Server 2005.

Comments

Popular posts from this blog

My family genealogy : Kurmi

How to report software piracy in India

Posting a Silverlight Streaming video on ur blog