Hyper Threading

Hi All,
Does anyone know if there are any issues with HT processors and either SQL
2000 or MSDE 2000?
Thanks
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 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 Server up for the number of Physical processors and not logical.
Thanks
"Mike Hodgson" <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 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 Physical 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:eg0xCTfdFHA.3032@.TK2MSFTNGP10.phx.gbl...
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:
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> 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 All,
Does anyone know if there are any issues with HT processors and either SQL
2000 or MSDE 2000?
Thanks