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.

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

quote:

---

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

quote:

---

> How it is with hypertrading with sql 2000, better performance when its

---

turn on, or turn of.