Count Cores

SELECT cpu_count
FROM sys.dm_os_sys_info
GO

CREATE TABLE #tempCore
([Index] VARCHAR(2000),
[Name] VARCHAR(2000),
[Internal_Value] VARCHAR(2000),
[Character_Value] VARCHAR(2000)) ;
INSERT INTO #tempCore
EXEC xp_msver;
SELECT Internal_Value AS VirtualCPUCount
FROM #tempCore
WHERE Name = 'ProcessorCount';
DROP TABLE #tempCore