Hypertrading and SQL server 2000

How it is with hypertrading with sql 2000, better performance when its turn on, or turn of.From what I have heard SQL Server benefits from hyperthreading in the same
way as it benefits from multiple processors... but I do not know to what
expent you might expect to see any improvement..
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Audrius" <reiktu@.hotmail.com> wrote in message
news:927B3DC0-A098-4701-BF8E-A64AD43D0421@.microsoft.com...
> How it is with hypertrading with sql 2000, better performance when its
turn on, or turn of.|||There's an interesting article on parallel queries at
http://www.sql-server-performance.com/jc_parallel_execution_plans.asp that
includes a section (at the bottom of the article) looking at HT performance
that might be of interest. Also if you search the forum on that site you'll
see a fair bit of discussion on HT performance
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Audrius" <reiktu@.hotmail.com> wrote in message
news:927B3DC0-A098-4701-BF8E-A64AD43D0421@.microsoft.com...
> How it is with hypertrading with sql 2000, better performance when its
turn on, or turn of.