SQL and ML Spaces

select cpu_count/hyperthread_ratio AS sockets from sys.dm_os_sys_info — How many sockets does my machine have?
select hyperthread_ratio AS cores_or_logical_cpus_per_socket from sys.dm_os_sys_info — How many either cores or logical CPU share the same socket?
select physical_memory_in_bytes/1024 AS physical_memory_in_kb from sys.dm_os_sys_info — How much physical memory my machine has?
select max_workers_count from sys.dm_os_sys_info — How many threads/workers SQL Server would use if the default value in sp_configure for max worker threads is zero:
select bpool_visible from sys.dm_os_sys_info — What is a size of AWE window or what is the max amount of memory right now that can be used by QO, QE and Caches simultaneously when SQL Server running in AWE mode?