what is Hyperthred ratio?

• Oracle_91

  SSChampion

  Points: 14548

  More actions

  July 22, 2014 at 11:10 am

  #309437

  Hi,

  In layman terms, what is hyperthread ratio mean? How is it used/useful in sql server ?

  Books online says, It is the Ratio of the number of logical and physical processors.

  I have executed one of Glenn Berry's DMV query on my laptop and gives me the below output.

  SELECT cpu_count AS [Logical CPU Count],

  hyperthread_ratio AS [Hyperthread Ratio],

  cpu_count/hyperthread_ratio AS [Physical CPU Count],

  physical_memory_in_bytes/1048576 AS [Physical Memory (MB)], sqlserver_start_time

  FROM sys.dm_os_sys_info WITH (NOLOCK) OPTION (RECOMPILE);

  Logical CPU CountHyperthread RatioPhysical CPU CountPhysical Memory (MB)sqlserver_start_time

  22140862014-07-22 16:24:47.377

  Thanks in advance.