Get SQL Server Hardware Information

With the help of the sys.dm_os_sys_info system view we will get the sql server hardware information.

select * from  sys.dm_os_sys_info

See the output

Get more information

https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-os-sys-info-transact-sql

The cpu_count returns the number of logical CPUs and hyperthread_ratio returns ratio between 

physical and logical CPUs. I find the hyperthread_ratio to be confusing as it does not tell whether
these are the actual hyper threaded cores or the physical cores. So I can never find out which 

processor is the server using. The physical_memory_kb tells the amount of RAM in my 
server and how much of it is committed using committed_kb. The sqlserver_start_time is useful 

to find since what date and time SQL Server has been running. Find the Most Used Stored 
Procedures in SQL Server