Post reply

How do we turn off/on hyperthreading in sql server 2008 R2 ?

  • June 28, 2014 at 11:54 pm

    #288024

    Hi Experts,

    How do we turn off/on hyperthreading in sql server 2008 R2 ?

    Is there any parameters to set while turning it on or off ?

    I googled a bit regarding hyperthreading and confused, to enable or disable it 🙂 .

    Any suggestions from your own experience ?

    Thanks,

    Smith.

  • June 29, 2014 at 2:51 am

    #1725710

    Hyperthreading is OS option and you can enable\disable it from BIOS.

    In sql server you can set processor affinity,IO affinity ,worker threads etc.

  • July 10, 2014 at 8:56 am

    #1728421

    Hyperthreading and its recommendation to turn it on or off has flip-flopped a number of times since the first Pentium Xeon chipset. We turn it off by default and have achieved good results. However a lot of the documentation now says 'your milage will vary' meaning you should performance/load test with it on and off and make your own decision.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply