Information on CPU count

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  April 17, 2008 at 12:56 pm

  #185556

  Hi All,

  Is there a way from SQL Server where we can find the information on the number of physical/logical processors in the servers. I know that we have some utilities that can be used. But i need to know if this can be done with SQL Server scripts. If so i would be thankful if you can post me the script.

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com

• matt stockham

  SSCrazy Eights

  Points: 9942

  More actions

  April 17, 2008 at 10:39 pm

  #804093

  sys.dm_os_sys_info gives cpu information, but I don't think it's accurate for hyperthreading.