查看SQL Server有几个 NUMA 节点及CPU情况

来源:互联网 发布:mysql教程pdf 编辑:程序博客网 时间:2024/06/05 19:39
SELECT DISTINCT memory_node_id FROM sys.dm_os_memory_clerks


SELECT cpu_count AS [Logical CPUs],cpu_count / hyperthread_ratio AS [Physical CPUs]FROM sys.dm_os_sys_info