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.
Thanks
Have a look here:
http://blogs.msdn.com/slavao/archive...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