Results 1 to 6 of 6
  1. #1
    Join Date
    Jun 2005
    Posts
    44

    Unanswered: 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?

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Never had the need....I'll have to read up on this.....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    OK, I'll go with gimicky

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

    Just scale the box
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Jun 2005
    Posts
    44
    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

    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

  5. #5
    Join Date
    Jun 2005
    Posts
    44
    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.


  6. #6
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •