Finding Count of Logical CPU using T-SQL Script – Identify Virtual Processors

Tìm logical cpu

SELECT cpu_countFROM sys.dm_os_sys_info

http://blog.sqlauthority.com/2012/02/04/sql-server-finding-count-of-logical-cpu-using-t-sql-script-identify-virtual-processors/

Nếu muốn tìm physical cpu thì dùng lệnh sau:

SELECT cpu_count / hyperthread_ratio AS physical_cpu_sockets
FROM sys.dm_os_sys_info ;

Tìm hiểu thông tin về CPU, ví dụ Core I5, I7, Quad Core...

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