Home Forums SQL Server 2008 SQL Server 2008 Administration Logical CPU Count and Hyperthread Ratio ? RE: Logical CPU Count and Hyperthread Ratio ?

  • April 4, 2013 at 5:37 am

    #1603495

    I got it.. according to SQL output 16 Logical CPU...

    Pl. correct me if am wrong direction.

    For the performance basis for SQL SERVER parallel processing should be equal number as blow,

    Logical CPU Count - 16

    Hyperthread Ratio – 16

    As per query output, currently display as below

    Logical CPU Count - 16

    Hyperthread Ratio - 8

    how it is enable at HW level or SQL side to make Hyperthread Ratio = 16?

    thnaks

    ananda