Search notes:

SQL Server - sys.dm_os_sys_info

The sys.dm_os_sys_info view returns one row only.
select
   cpu_ticks
   ms_ticks,
   cpu_count,
   hyperthread_ratio,
   physical_memory_kb,
   virtual_memory_kb,
   committed_kb,
   committed_target_kb,
   visible_target_kb,
   stack_size_in_bytes,
   os_quantum,
   os_error_mode,
   os_priority_class,
   max_workers_count,
   scheduler_count,
   scheduler_total_count,
   deadlock_monitor_serial_number,
   sqlserver_start_time_ms_ticks,
   sqlserver_start_time,
   affinity_type,
   affinity_type_desc,
   process_kernel_time_ms,
   process_user_time_ms,
   time_source,
   time_source_desc,
   virtual_machine_type,
   virtual_machine_type_desc,
   softnuma_configuration,
   softnuma_configuration_desc,
   process_physical_affinity,
   sql_memory_model,
   sql_memory_model_desc,
   socket_count,
   cores_per_socket,
   numa_node_count
from
   sys.dm_os_sys_info

Index