Waseem Jaleel (7/28/2008)
I thank all of you for all the responses, this has been very useful to me, I have finally decided to use the xp_msver, by Gail Shaw. Thank you very much once again.
I know this is a really old thread but I found it through Google looking for something else so I am confident others will too. xp_msver does not show physical CPU sockets, it shows logical processors.
This will show you the number of physical sockets on your server:
SELECT cpu_count / hyperthread_ratio AS physical_cpu_sockets
FROM sys.dm_os_sys_info ;
Credit: http://sqlblog.com/blogs/kalen_delaney/archive/2007/12/08/hyperthreaded-or-not.aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato