gistfile1.sql

USE MASTER

DECLARE @MemoryDenominator INT
SET @MemoryDenominator = 1048576

select 
cpu_count [CPUs]
,hyperthread_ratio [Hyperthread Ratio]
,physical_memory_in_bytes / @MemoryDenominator as [Memory (MB)]
,virtual_memory_in_bytes / @MemoryDenominator as [Virtual Memory (MB)]
,max_workers_count [Max Worker Count]
,os_error_mode [OS Error Mode]
,os_priority_class [OS Priority Class]
from  sys.dm_os_sys_info 


--Results--


CPUs,	Hyperthread Ratio,	Memory (MB),	Virtual Memory (MB),	Max Worker Count,	OS Error Mode,	OS Priority Class
 2	         1	            4095	            8388607	               512	           5	                32