Wednesday, March 7, 2012

Hyper-Threading with SQL 2000 Standard

We just purchased a quad processor server running windows
2003. The processors are xeon so they have HTT
capability. Will SQL200 recognize all eight logical
processor or will it only see four. I wan't to find out
before we install SQL 2000. Thanks.With sp3 it should use all eight.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Stephen" <anonymous@.discussions.microsoft.com> wrote in message
news:297901c3af9b$78aa3c40$a601280a@.phx.gbl...
> We just purchased a quad processor server running windows
> 2003. The processors are xeon so they have HTT
> capability. Will SQL200 recognize all eight logical
> processor or will it only see four. I wan't to find out
> before we install SQL 2000. Thanks.|||Here's a good white-paper on hyper-threading for various Windows OS'
http://www.microsoft.com/windows2000/server/evaluation/performance/reports/hyperthread.asp
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se> wrote in message news:<OS1YGh6rDHA.2456@.TK2MSFTNGP12.phx.gbl>...
> With sp3 it should use all eight.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "Stephen" <anonymous@.discussions.microsoft.com> wrote in message
> news:297901c3af9b$78aa3c40$a601280a@.phx.gbl...
> > We just purchased a quad processor server running windows
> > 2003. The processors are xeon so they have HTT
> > capability. Will SQL200 recognize all eight logical
> > processor or will it only see four. I wan't to find out
> > before we install SQL 2000. Thanks.

No comments:

Post a Comment