dm_os_sys_info


Columns

Column Type Size Nulls Auto Default Children Parents Comments
cpu_ticks bigint 8 null
ms_ticks bigint 8 null
cpu_count int 4 null
hyperthread_ratio int 4 null
physical_memory_kb bigint 8 null
virtual_memory_kb bigint 8 null
committed_kb bigint 8 null
committed_target_kb bigint 8 null
visible_target_kb bigint 8 null
stack_size_in_bytes int 4 null
os_quantum bigint 8 null
os_error_mode int 4 null
os_priority_class int 4 √ null
max_workers_count int 4 null
scheduler_count int 4 null
scheduler_total_count int 4 null
deadlock_monitor_serial_number int 4 null
sqlserver_start_time_ms_ticks bigint 8 null
sqlserver_start_time datetime 16,3 null
affinity_type int 4 null
affinity_type_desc nvarchar 120 null
process_kernel_time_ms bigint 8 null
process_user_time_ms bigint 8 null
time_source int 4 null
time_source_desc nvarchar 120 null
virtual_machine_type int 4 null
virtual_machine_type_desc nvarchar 120 null
softnuma_configuration int 4 null
softnuma_configuration_desc nvarchar 120 null
process_physical_affinity nvarchar 6144 null
sql_memory_model int 4 null
sql_memory_model_desc nvarchar 120 null
socket_count int 4 null
cores_per_socket int 4 null
numa_node_count int 4 null
container_type int 4 null
container_type_desc nvarchar 120 null

Relationships

Close relationships within degrees of separation