How to find the number of sockets in sql server 2000,2005 and 2008 version?

• KumarVelayutham

  SSCrazy

  Points: 2204

  More actions

  November 8, 2011 at 4:03 am

  #262511

  Sql server licensing is based on number of sockets.that why i am in need to know the number of sockets using query in sql server 2000,2005 and 2008 version?

  Help me.

  Regards,
  Kumar

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  November 8, 2011 at 4:38 am

  #1404359

  In SQL Server 2005/2008 you can issue this:

  select socket_count = cpu_count / hyperthread_ratio

  from sys.dm_os_sys_info

  In SQL Server 2000 I'm not aware of any way of querying this.

  -- Gianluca Sartori