hyper threading: threading

Showing posts with label threading. Show all posts

Sunday, February 19, 2012

Hyper Threadng with SQL 2000 ?

Is it better to enable Hyper Threading on a DB machine. I am running only SQL 2000 on my machine no other service is running. I have noticed in Task Manager that in peak time when there is some load on DB one Proccesor proccesing goes to 100 % while other reamin idle or maximum go to 20 to 30 %. I want whole peoccesing for database only.

If some one has any tips for improving database performance then please share it.mmmmmmmmm

Heres a good link to HyperThreading if anyones interested

http://www.2cpu.com/articles/42_2.html

But Beware as YOUR SERVER HARDWARE MUST SUPPORT THIS NEW Technology

and as Intel say

Performance will vary depending on the specific hardware and software you use. but could provide a performance increase in the neighborhood of 10-30%, depending on the application and the situation

If your really interested you could set up 2 test machines and try it but IMHO... I think your barking up the wrong tree as far as Twin/Quad CPU Usage balancing is concerned.

As far as tips for improving database performance try

Higher Spec Hardware & more RAM,
Transaction file physically stored on a seperate Hard Disk away from the RAID Array of the Data File,
Tune Indexes & tweak sloppy Querys etc...etc...etc...etc...etc...etc...etc...etc. ..

GW|||The most important thing I've read is to limit the max degreee of parallelism to the number of physical processors when using HT.

Hyper Threading SQL 2000 Ent, Windows 2003 4GB RAM -> "Yes" or "No

Hi
What would be the best practice on subject? Are there any resources I should
read?
Our server have 2xXEON CPU's and 4 with HT (All are enabled on our SQL
2000), but we have some performance issue.
Thanks
Have a look here:
http://blogs.msdn.com/slavao/archive...12/492119.aspx
Bottom line is that you don't know for sure until you test it both ways
under the exact conditions you will run with. Sometimes it helps sometimes
it hurts.
Andrew J. Kelly SQL MVP
"Core" <Core@.discussions.microsoft.com> wrote in message
news:3E7FB0BD-07D0-426D-94D3-4BE515D0FE7A@.microsoft.com...
> Hi
> What would be the best practice on subject? Are there any resources I
> should
> read?
> Our server have 2xXEON CPU's and 4 with HT (All are enabled on our SQL
> 2000), but we have some performance issue.
> Thanks

Hyper Threading SQL 2000 Ent, Windows 2003 4GB RAM -> "Yes" or "No

Hi
What would be the best practice on subject? Are there any resources I should
read?
Our server have 2xXEON CPU's and 4 with HT (All are enabled on our SQL
2000), but we have some performance issue.
ThanksHave a look here:
http://blogs.msdn.com/slavao/archiv.../12/492119.aspx
Bottom line is that you don't know for sure until you test it both ways
under the exact conditions you will run with. Sometimes it helps sometimes
it hurts.
Andrew J. Kelly SQL MVP
"Core" <Core@.discussions.microsoft.com> wrote in message
news:3E7FB0BD-07D0-426D-94D3-4BE515D0FE7A@.microsoft.com...
> Hi
> What would be the best practice on subject? Are there any resources I
> should
> read?
> Our server have 2xXEON CPU's and 4 with HT (All are enabled on our SQL
> 2000), but we have some performance issue.
> Thanks

Hyper Threading SQL 2000 Ent, Windows 2003 4GB RAM -> "Yes" or "No

Hi
What would be the best practice on subject? Are there any resources I should
read?
Our server have 2xXEON CPU's and 4 with HT (All are enabled on our SQL
2000), but we have some performance issue.
ThanksHave a look here:
http://blogs.msdn.com/slavao/archive/2005/11/12/492119.aspx
Bottom line is that you don't know for sure until you test it both ways
under the exact conditions you will run with. Sometimes it helps sometimes
it hurts.
--
Andrew J. Kelly SQL MVP
"Core" <Core@.discussions.microsoft.com> wrote in message
news:3E7FB0BD-07D0-426D-94D3-4BE515D0FE7A@.microsoft.com...
> Hi
> What would be the best practice on subject? Are there any resources I
> should
> read?
> Our server have 2xXEON CPU's and 4 with HT (All are enabled on our SQL
> 2000), but we have some performance issue.
> Thanks

Hyper Threading for a cluster envirnoment

Hi
We are running SQL server in a cluster environment and Hyper threading are
enabled in that servers. The application and Database servers are
different. The appliactions stores 2 MB size of acrobat files to the table
which contains more than 600000 records . We are finding some kind of
issues with this servers.
Couple of SQL DBAs mentioning that , Hyder threading needs to disable in
that server .Is hyper threading cause any issue related to SQL Server
envirnoment.
Please reply
Regards
Swami
ganesh2012@.hotmail.com
Hi
I see no reason why you should. HT processors act like there are 2
processors installed.
What issues are you having?
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Swami" <Swami@.discussions.microsoft.com> wrote in message
news:54181388-7DEA-46D4-AA5E-D183BE5846E5@.microsoft.com...
> Hi
> We are running SQL server in a cluster environment and Hyper threading
are
> enabled in that servers. The application and Database servers are
> different. The appliactions stores 2 MB size of acrobat files to the
table
> which contains more than 600000 records . We are finding some kind of
> issues with this servers.
> Couple of SQL DBAs mentioning that , Hyder threading needs to disable in
> that server .Is hyper threading cause any issue related to SQL Server
> envirnoment.
> Please reply
> Regards
> Swami
> ganesh2012@.hotmail.com
>
|||In general, hyperthreading is a good thing. There are some strange
behaviors on 8 or more processor clusters but these only happen under some
very specific conditions. I do find that you will need to lower the
maximium degree of parallelism to the actual physical processor count to
avoid oversaturating a system. Please reply with more details on exactly
what your symptoms are so someone here can give you a better answer.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Swami" <Swami@.discussions.microsoft.com> wrote in message
news:54181388-7DEA-46D4-AA5E-D183BE5846E5@.microsoft.com...
> Hi
> We are running SQL server in a cluster environment and Hyper threading
are
> enabled in that servers. The application and Database servers are
> different. The appliactions stores 2 MB size of acrobat files to the
table
> which contains more than 600000 records . We are finding some kind of
> issues with this servers.
> Couple of SQL DBAs mentioning that , Hyder threading needs to disable in
> that server .Is hyper threading cause any issue related to SQL Server
> envirnoment.
> Please reply
> Regards
> Swami
> ganesh2012@.hotmail.com
>
|||Geoff N. Hiten wrote:

> In general, hyperthreading is a good thing.

> There are some strange
> behaviors on 8 or more processor clusters but these only happen under some
> very specific conditions.
Could jou post a link to some info on this?
Hans
|||Here is one I actually oberved. It is a very unusual set of circumstances
that caused the problem.
FIX: Intermittent query slowdowns and corresponding high CPU utilization
http://support.microsoft.com/default.aspx/kb/835864
Here was another fix earlier to handle some other synchronization
performance issues.
FIX: Intense SQL Server Activity Results in Spinloop Wait in SQL Server 2000
Service Pack 2
http://support.microsoft.com/default...b;en-us;818763
I am pretty sure SP2 had something in it for Hyperthreading, most likely
counting the processors correctly for licensing restrictions.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Hans de Bruin" <hans@.invalid.invalid> wrote in message
news:1107960610.727258@.draco.amc.uva.nl...[vbcol=seagreen]
> Geoff N. Hiten wrote:
>
some
> Could jou post a link to some info on this?
> --
> Hans

Hyper Threading - Good or Bad?

Ello,

We have quite a few SQL Servers running on servers with hyper threaded enabled processors. We have always left hyper threading on, even on our very busy servers but i've recently begun to question this due to comments i have received.

All our servers run SQL 2000 SP3a as "support" for hyper threading was added in SP3a

So... What do you think of Hyper Threading any why?Never had the need...I'll have to read up on this....|||OK, I'll go with gimicky

www.microsoft.com/sql/howtobuy/SQLonHTT.doc

Just scale the box|||Thanks Brett.

It will be good to compare notes, my hunt for information has not found much for or against yet although when trouble shooting we are now always advised to turn it off...

This link to a newgroup article raised my eyebrow
News Group (http://groups.google.co.uk/group/microsoft.public.sqlserver.server/browse_frm/thread/99860c74db9d183/af9e69650569f1db?lnk=st&q=hyper+threading+%2B+SQL+performance&rnum=2&hl=en#af9e69650569f1db)

Quoting a MVP from the link he says

The problem with a HT CPU that the 2 simultaneous threads running on the CPU both contend for the *same* L1, L2 and L3 processor cache. During heavy processing, you may actually have the 2 clearing each other's cache. This results in each having to go to main system RAM to work.

But read the whole thing for context as he also talks about parallelism|||Yes i read that but the other post has spurred me on to get the internet shovel out and keep hunting for more information and post for peoples experiences.

:D|||I have been told that Windows Server 2003 has better support for Hyperthreading. If you can, get your SQL Servers running on 2003, and all should be well. We have had no problems on 2003, or 2000, though.

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

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
>.
>

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

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--

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
OskarOskar,
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...
>> 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
>|||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
>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
>.
>

Sunday, February 19, 2012

Hyper Threadng with SQL 2000 ?

Hyper Threading SQL 2000 Ent, Windows 2003 4GB RAM -> "Yes" or "No

Hyper Threading SQL 2000 Ent, Windows 2003 4GB RAM -> "Yes" or "No

Hyper Threading SQL 2000 Ent, Windows 2003 4GB RAM -> "Yes" or "No

Hyper Threading for a cluster envirnoment

Hyper Threading - Good or Bad?

Hyper Threading

hyper threading

Hyper Threading

Hyper Threading

hyper threading

hyper threading

Blog Archive

About Me