hyper threading: Hyper Threading

Hi All,
Does anyone know if there are any issues with HT processors and either SQL
2000 or MSDE 2000?
ThanksThis is a multi-part message in MIME format.
--080700010501060407070309
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
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
>
>
--080700010501060407070309
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>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. 
</tt>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
-- 
 mike
hodgson | database administrator
| mallesons stephen jaques 
T +61 (2) 9296 3668 | F +61
(2) 9296 3885 | M +61
(408) 675 907 
E
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> | W <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a> 
</div>
 
 
Jason Fischer wrote:
<blockquote cite="mideHTk3GUdFHA.3184@.TK2MSFTNGP15.phx.gbl" type="cite">
<pre wrap="">Hi All,
Does anyone know if there are any issues with HT processors and either SQL
2000 or MSDE 2000?
Thanks
</pre>
</blockquote>
</body>
</html>
--080700010501060407070309--|||This is a multi-part message in MIME format.
--=_NextPart_000_0008_01C57634.DCC06360
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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=20
Jason Fischer wrote: Hi All,
Does anyone know if there are any issues with HT processors and either =SQL 2000 or MSDE 2000?
Thanks
--=_NextPart_000_0008_01C57634.DCC06360
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

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" 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 jaquesT +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907E mailto:mike.hodgson@.mal=lesons.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

--=_NextPart_000_0008_01C57634.DCC06360--|||This is a multi-part message in MIME format.
--020104030608090806080107
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
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
> <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 All,
>>Does anyone know if there are any issues with HT processors and either SQL
>>2000 or MSDE 2000?
>>Thanks
>>
>>
--020104030608090806080107
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>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.)</tt> 
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
-- 
 mike
hodgson | database administrator
| mallesons stephen jaques 
T +61 (2) 9296 3668 | F +61
(2) 9296 3885 | M +61
(408) 675 907 
E
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> | W <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a> 
</div>
 
 
Jason Fischer wrote:
<blockquote cite="midOTigIFedFHA.2736@.TK2MSFTNGP12.phx.gbl" type="cite">
<title></title>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<meta content="MSHTML 6.00.2900.2668" name="GENERATOR">
<style></style>
<div>Hi Mike,</div>
<div> </div>
<div>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.</div>
<div> </div>
<div>Thanks</div>
<div> </div>
<blockquote
style="border-left: 2px solid rgb(0, 0, 0); padding-right: 0px; padding-left: 5px; margin-left: 5px; margin-right: 0px;"
dir="ltr">
<div>"Mike Hodgson" <<a
href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">mike.hodgson@.mallesons.nospam.com</a>>
wrote in message <a href="http://links.10026.com/?link=news:OvIdEUUdFHA.3808@.TK2MSFTNGP14.phx.gbl">news:OvIdEUUdFHA.3808@.TK2MSFTNGP14.phx.gbl</a>...</div>
<tt>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. 
</tt>
<div class="moz-signature">
-- 
mike
hodgson | database administrator
| mallesons stephen jaques 
T +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907 
E <a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">mailto:mike.hodgson@.mallesons.nospam.com</a>
| W <a href="http://links.10026.com/?link=http://www.mallesons.com</a>">http://www.mallesons.com">http://www.mallesons.com</a>

</div>
 
 
Jason Fischer wrote:
<blockquote cite="mideHTk3GUdFHA.3184@.TK2MSFTNGP15.phx.gbl"
type="cite">
<pre wrap="">Hi All,
Does anyone know if there are any issues with HT processors and either SQL
2000 or MSDE 2000?
Thanks
</pre>
</blockquote>
</blockquote>
</blockquote>
</body>
</html>
--020104030608090806080107--|||This is a multi-part message in MIME format.
--=_NextPart_000_000E_01C57724.460926A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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=20
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=20
Jason Fischer wrote: Hi All,
Does anyone know if there are any issues with HT processors and either =SQL 2000 or MSDE 2000?
Thanks
--=_NextPart_000_000E_01C57724.460926A0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

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" 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 jaquesT +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907E mailto:mike.hodgson@.mal=lesons.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" 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 =jaquesT =+61 (2) 9296 3668 | F +61 (2) 9296 =3885 | M +61 (408) 675 907E mailto:mike.hodgson@.mal=lesons.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 =

--=_NextPart_000_000E_01C57724.460926A0--

Sunday, February 19, 2012

Hyper Threading

No comments:

Post a Comment

hyper threading

Blog Archive

About Me