Find System information using SQL Server

How to find System information in SQl Server using Select Statement below,

SELECT * FROM sys.dm_os_sys_info

Get from the Particular fields above query,

SELECT CPU_Count,HyperThread_Ratio,Physical_Memory_In_Bytes / 1048576 as ‘Memory_In_MB’,Virtual_Memory_In_Bytes / 1048576 as ‘Virtual_Memory_In_MB’,
Max_Workers_Count,OS_Error_Mode,OS_Priority_Class FROM sys.dm_os_sys_info

Results :

CPU_Count   HyperThread_Ratio Memory_In_MB         Virtual_Memory_In_MB Max_Workers_Count OS_Error_Mode OS_Priority_Class
———– —————– ——————– ——————– —————– ————- —————–
2           2                 1013                 2047                 256               5             32

Reference : http://source.witssquare.com

Tags: find system info, Find System information using SQL Server, how to find system info, information, SQL Server, sys.dm_os_sys_info, System information