Sunday, February 19, 2012

Hyper Threading SQL 2000 Ent, Windows 2003 4GB RAM -> "Yes" or "No

Hi
What would be the best practice on subject? Are there any resources I should
read?
Our server have 2xXEON CPU's and 4 with HT (All are enabled on our SQL
2000), but we have some performance issue.
ThanksHave a look here:
http://blogs.msdn.com/slavao/archive/2005/11/12/492119.aspx
Bottom line is that you don't know for sure until you test it both ways
under the exact conditions you will run with. Sometimes it helps sometimes
it hurts.
--
Andrew J. Kelly SQL MVP
"Core" <Core@.discussions.microsoft.com> wrote in message
news:3E7FB0BD-07D0-426D-94D3-4BE515D0FE7A@.microsoft.com...
> Hi
> What would be the best practice on subject? Are there any resources I
> should
> read?
> Our server have 2xXEON CPU's and 4 with HT (All are enabled on our SQL
> 2000), but we have some performance issue.
> Thanks

No comments:

Post a Comment