Tuesday, December 6, 2011

Query to get CPU and memory Information

Run below query to get the CPU and memory information:

EXEC xp_instance_regread 'HKEY_LOCAL_MACHINE', 'HARDWARE\DESCRIPTION\System\CentralProcessor\0', 'ProcessorNameString';

-- Query to get CPU and Memory Info
SELECT CPU_Count AS [No. of Logical CPU], CPU_Count/Hyperthread_Ratio AS [No of Physical CPU], Physical_Memory_In_Bytes/1048576 AS [Total Physical Memory (MB)] 
FROM sys.dm_os_sys_info OPTION (RECOMPILE)

No comments:

Post a Comment