Server logical CPU and Physical CPU Cores

• CuriousDBA

  Old Hand

  Points: 387

  More actions

  November 9, 2012 at 2:02 am

  #266841

  I tried to find out Logical CPU count of my Laptop, Got two different counts.

  I ran the following query SELECT cpu_count FROM sys.dm_os_sys_info and its shows 4 Logical CPUs (Cpu_count)

  My Physical processor is Intel 5i 2410M. with 2 cores and 4 Threads.

  Please advice which count i have to consider to split My tempdb (Only for testing) ? 2 or 4?

• Ant-Green

  SSC Guru

  Points: 113563

  More actions

  November 9, 2012 at 2:07 am

  #1557495

  To get the physical number of CPU's in a box

  SELECT

  cpu_count / hyperthread_ratio AS PhysicalCPUs

  FROM

  sys.dm_os_sys_info

  To get the number of logical CPU's in a box

  SELECT

  cpu_count AS logicalCPUs

  FROM

  sys.dm_os_sys_info

  Myths About TempDB 1 File Per Core[/code]

  Personally I would only ever split TempDB up if you have performance issues with TempDB.