Hyper Threading

Hi All,
Does anyone know if there are any issues with HT processors and either SQL
2000 or MSDE 2000?
ThanksI've never heard of any or seen any myself (and we've been running SQL
2000 instances on hyper-threaded CPUs for some time). Admittedly we
don't play with MSDE but it's the same code-base.
I think at that level it's the OS implementation that may or may not
have issues, not the app server (i.e. SQL Server). SQL Server just
presents the work for a specific logical processor to the O/S kernel to
deal with.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Jason Fischer wrote:

>Hi All,
>Does anyone know if there are any issues with HT processors and either SQL
>2000 or MSDE 2000?
>Thanks
>
>|||Hi Mike,
I had just read a whole lot of things saying that you should set your SQL Se
rver up for the number of Physical processors and not logical.
Thanks
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message news:OvI
dEUUdFHA.3808@.TK2MSFTNGP14.phx.gbl...
I've never heard of any or seen any myself (and we've been running SQL 2000
instances on hyper-threaded CPUs for some time). Admittedly we don't play w
ith MSDE but it's the same code-base.
I think at that level it's the OS implementation that may or may not have is
sues, not the app server (i.e. SQL Server). SQL Server just presents the wo
rk for a specific logical processor to the O/S kernel to deal with.
mike hodgson | database administrator | mallesons stephen jaques
T +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907
E mailto:mike.hodgson@.mallesons.nospam.com | W http://www.mallesons.com
Jason Fischer wrote:
Hi All,
Does anyone know if there are any issues with HT processors and either SQL
2000 or MSDE 2000?
Thanks|||Interesting. Did those things you read say why? Were they referring to
processor affinity, licensing or something else? (We've been running a
couple clusters on dual-proc hyper-threaded Xeon boxes (showing 4
logical procs) for some time with no processor related problems that I'm
aware of.)
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Jason Fischer wrote:
[vbcol=seagreen]
> Hi Mike,
> I had just read a whole lot of things saying that you should set your
> SQL Server up for the number of Physical processors and not logical.
> Thanks
>
> "Mike Hodgson" <mike.hodgson@.mallesons.nospam.com
> <mailto:mike.hodgson@.mallesons.nospam.com>> wrote in message
> news:OvIdEUUdFHA.3808@.TK2MSFTNGP14.phx.gbl...
> I've never heard of any or seen any myself (and we've been running
> SQL 2000 instances on hyper-threaded CPUs for some time).
> Admittedly we don't play with MSDE but it's the same code-base.
> I think at that level it's the OS implementation that may or may
> not have issues, not the app server (i.e. SQL Server). SQL Server
> just presents the work for a specific logical processor to the O/S
> kernel to deal with.
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
> http://www.mallesons.com
>
> Jason Fischer wrote:
>|||Hi Mike,
The articles mentioned something about L2, L3 chace being overwritten due to
HT causing a slow down instead of an increase in spead. The SQL statements
just take longer, the moment they set SQL Server to just use the number of P
hysical processors, everything goes back to normal.
I will try and find the articles again and post the links, but will be away
from a PC for 2 weeks, so it might be a while before I post again.
Thanks
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message news:eg0
xCTfdFHA.3032@.TK2MSFTNGP10.phx.gbl...
Interesting. Did those things you read say why? Were they referring to pro
cessor affinity, licensing or something else? (We've been running a couple
clusters on dual-proc hyper-threaded Xeon boxes (showing 4 logical procs) fo
r some time with no processor related problems that I'm aware of.)
mike hodgson | database administrator | mallesons stephen jaques
T +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907
E mailto:mike.hodgson@.mallesons.nospam.com | W http://www.mallesons.com
Jason Fischer wrote:
Hi Mike,
I had just read a whole lot of things saying that you should set your SQL Se
rver up for the number of Physical processors and not logical.
Thanks
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message news:OvI
dEUUdFHA.3808@.TK2MSFTNGP14.phx.gbl...
I've never heard of any or seen any myself (and we've been running SQL 2000
instances on hyper-threaded CPUs for some time). Admittedly we don't play w
ith MSDE but it's the same code-base.
I think at that level it's the OS implementation that may or may not have is
sues, not the app server (i.e. SQL Server). SQL Server just presents the wo
rk for a specific logical processor to the O/S kernel to deal with.
mike hodgson | database administrator | mallesons stephen jaques
T +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907
E mailto:mike.hodgson@.mallesons.nospam.com | W http://www.mallesons.com
Jason Fischer wrote:
Hi All,
Does anyone know if there are any issues with HT processors and either SQL
2000 or MSDE 2000?
Thanks