disable hyperthreading

I would like to know how can I disable hyperthreading in sql server 2000? Do
I have to reboot the server after disabling hyperthreading?
Is it better to disable hyperthreading at SQL Server 2000 level or should it
be done from the BIOS? Thanks in advance.You should do this in the BIOS. You can minimize its effect on SQL by
setting the MAXDOP to 1 or the number of physical processors.
Jason Massie
Web: http://statisticsio.com
RSS: http://feeds.feedburner.com/statisticsio
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:4CF15D21-4B94-4730-91D4-A103BEAB505F@.microsoft.com...
>I would like to know how can I disable hyperthreading in sql server 2000?
>Do
> I have to reboot the server after disabling hyperthreading?
> Is it better to disable hyperthreading at SQL Server 2000 level or should
> it
> be done from the BIOS? Thanks in advance.|||... or configuring affinity mask so only one logical processor per physical
processor is used. This
requires a re-start of the database engine in 2000. I agree that BIOS is pre
ferred.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
news:OAt2suAPIHA.280@.TK2MSFTNGP03.phx.gbl...
> You should do this in the BIOS. You can minimize its effect on SQL by sett
ing the MAXDOP to 1 or
> the number of physical processors.
>
> --
> Jason Massie
> Web: http://statisticsio.com
> RSS: http://feeds.feedburner.com/statisticsio
> "sharman" <sharman@.discussions.microsoft.com> wrote in message
> news:4CF15D21-4B94-4730-91D4-A103BEAB505F@.microsoft.com...
>|||Thanks for the response. So when you say to configure affinity mask so only
one logical processor per physical processor is used, how do I do that in
Enterprise Manager?
The reason I am asking is that I am getting the following errors on my two
processor SQL Server 2000 SP4 running on Windows 2000 Server SP4:
The Scheduler 1 appears to be hung. SPID 0, ECID 0, UMS Context 0x023339C0.
Error: 17883, Severity: 1, State: 0
Earlier we had SP3 installed and I was getting this error recorded in the
SQL Server error logs. After installing SP4, our Crystal Reports admin
reported this SQL Server error in Crystal Reports logs (this SQL Server also
has Crystal Reports databases on it). I had posted this question in forums
and I was advised to turn off Hyperthreading.
"Tibor Karaszi" wrote:

> ... or configuring affinity mask so only one logical processor per physica
l processor is used. This
> requires a re-start of the database engine in 2000. I agree that BIOS is p
referred.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Jason Massie" <jason**R3move**@.statisticsio.com> wrote in message
> news:OAt2suAPIHA.280@.TK2MSFTNGP03.phx.gbl...
>|||Check out Books Online for sp_configure and the option "affinity mask". You
need to figure out how
your machine lay out the virtual processors over the physical processors fir
st and I believe that
Intel has such utility. I'm not sure that will help with the hung scheduler,
but it might be worth a
try...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:7876A292-922B-461D-96F8-B905D4356CBA@.microsoft.com...[vbcol=seagreen]
> Thanks for the response. So when you say to configure affinity mask so onl
y
> one logical processor per physical processor is used, how do I do that in
> Enterprise Manager?
> The reason I am asking is that I am getting the following errors on my two
> processor SQL Server 2000 SP4 running on Windows 2000 Server SP4:
> The Scheduler 1 appears to be hung. SPID 0, ECID 0, UMS Context 0x023339C0
.
> Error: 17883, Severity: 1, State: 0
> Earlier we had SP3 installed and I was getting this error recorded in the
> SQL Server error logs. After installing SP4, our Crystal Reports admin
> reported this SQL Server error in Crystal Reports logs (this SQL Server al
so
> has Crystal Reports databases on it). I had posted this question in forums
> and I was advised to turn off Hyperthreading.
> "Tibor Karaszi" wrote:
>|||See other posts about using BIOS to disable CPU hyperthreading.
SQL Server can parallelize work too, which you can disable with the MAXDOP
server setting or an OPTION hint for individual queries.
Kevin G. Boles
TheSQLGuru
Indicium Resources, Inc.
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:4CF15D21-4B94-4730-91D4-A103BEAB505F@.microsoft.com...
>I would like to know how can I disable hyperthreading in sql server 2000?
>Do
> I have to reboot the server after disabling hyperthreading?
> Is it better to disable hyperthreading at SQL Server 2000 level or should
> it
> be done from the BIOS? Thanks in advance.