hyper threading

Hi,
Are there any issues/benifits when running SQL Server 2000
EE SP3a/Windows 2000 Server SP4 on a machine that has CPUs
with hyper threading enabled?
Thanks
Oskar
Oskar,
Works for me - I have some 4 way servers with hyperthreading. I've not
heard of anything that would cause any issues. Make sure you are on the
latest service packs though (looks like you are).
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Oskar wrote:
> Hi,
> Are there any issues/benifits when running SQL Server 2000
> EE SP3a/Windows 2000 Server SP4 on a machine that has CPUs
> with hyper threading enabled?
> --
> Thanks
> Oskar
|||At a minimum... you might consider changing max degree of parrelism to the
PHYSICAL number of processors rather than the logical. I've seen many cases
where you'll have problems with cxpacket waits if you get a 4X plan on a box
with 2 physical but 4 logical processors...
Of course this isn't always true. But something to think about...
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Oskar" <anonymous@.discussions.microsoft.com> wrote in message
news:2df001c4a217$c7278520$a601280a@.phx.gbl...
> Hi,
> Are there any issues/benifits when running SQL Server 2000
> EE SP3a/Windows 2000 Server SP4 on a machine that has CPUs
> with hyper threading enabled?
> --
> Thanks
> Oskar
|||When is it true? And when is it NOT true?
Please give us details.
"Brian Moran" <brian@.solidqualitylearning.com> wrote in message
news:uQi0GkjoEHA.3900@.TK2MSFTNGP10.phx.gbl...
> At a minimum... you might consider changing max degree of parrelism to
> the
> PHYSICAL number of processors rather than the logical. I've seen many
> cases
> where you'll have problems with cxpacket waits if you get a 4X plan on a
> box
> with 2 physical but 4 logical processors...
> Of course this isn't always true. But something to think about...
> --
> Brian Moran
> Principal Mentor
> Solid Quality Learning
> SQL Server MVP
> http://www.solidqualitylearning.com
>
> "Oskar" <anonymous@.discussions.microsoft.com> wrote in message
> news:2df001c4a217$c7278520$a601280a@.phx.gbl...
>
|||Have you heard that any of post SP3(a) fixes help? I can't
find a confirmation of this on MS website though.
Oskar

>--Original Message--
>Oskar,
>Works for me - I have some 4 way servers with
hyperthreading. I've not
>heard of anything that would cause any issues. Make sure
you are on the[vbcol=seagreen]
>latest service packs though (looks like you are).
>--
>Mark Allison, SQL Server MVP
>http://www.markallison.co.uk
>Looking for a SQL Server replication book?
>http://www.nwsu.com/0974973602m.html
>
>Oskar wrote:
2000[vbcol=seagreen]
CPUs
>.
>