CXPACKET and XEON Processors

I have a question that I hope someone can answer. We are
running a WIN2K Server with SQL Server 2K SP 3. It is a
dual xeon processor machine with hyperthreading enabled.
I have noticed that the SQL PERF (Waitstats) CXPACKET is
much higher with xeon processors and was told that WIN2K3
would help with the lock times with the threading. Can
anyone speak to this? I have disabled the hyperthreading
at the BIOS level and noticed a higher level of
performance on the WIN2K machine.
Thanks
GregYou might try reducing 'max degree of parallelism' configuration option
rather than disable hyperthreading. If this is an OLTP system that
doesn't really benefit from parallel queries, try setting it to 1.
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"Greg" <greg@.stockamp.com> wrote in message
news:141001c3822d$d7be2d90$a001280a@.phx.gbl...
> I have a question that I hope someone can answer. We are
> running a WIN2K Server with SQL Server 2K SP 3. It is a
> dual xeon processor machine with hyperthreading enabled.
> I have noticed that the SQL PERF (Waitstats) CXPACKET is
> much higher with xeon processors and was told that WIN2K3
> would help with the lock times with the threading. Can
> anyone speak to this? I have disabled the hyperthreading
> at the BIOS level and noticed a higher level of
> performance on the WIN2K machine.
> Thanks
> Greg|||Waittype on CXPACKET is normal for parallel queries. Do not reduce MAXDOP
because you see waits on CXPACKET, reduce MAXDOP because you've proven it
makes queries you care about go faster.
--
Kevin Connell, MCDBA
----
The views expressed here are my own
and not of my employer.
----
"Greg" <greg@.stockamp.com> wrote in message
news:141001c3822d$d7be2d90$a001280a@.phx.gbl...
> I have a question that I hope someone can answer. We are
> running a WIN2K Server with SQL Server 2K SP 3. It is a
> dual xeon processor machine with hyperthreading enabled.
> I have noticed that the SQL PERF (Waitstats) CXPACKET is
> much higher with xeon processors and was told that WIN2K3
> would help with the lock times with the threading. Can
> anyone speak to this? I have disabled the hyperthreading
> at the BIOS level and noticed a higher level of
> performance on the WIN2K machine.
> Thanks
> Greg