select scheduler_id,cpu_id, status, is_online from sys.dm_os_schedulers
where status=’VISIBLE ONLINE’

SELECT cpu_count AS [Logical CPU Count], hyperthread_ratio AS Hyperthread_Ratio,
cpu_count/hyperthread_ratio AS Physical_CPU_Count,
physical_memory_kb/1024 AS Physical_Memory_in_MB,
sqlserver_start_time, affinity_type_desc 
FROM sys.dm_os_sys_info