查询dm_os_performance_counters显示我有2个NUMA节点:
select *
from sys.dm_os_performance_counters
where object_name = 'SQLServer:Buffer Node'
and counter_name = 'Page life expectancy'
查询sys.dm_os_sys_info显示:
Numa node count 4
CPU count 24
Softnumae_configuration 1
Socket_count 24
Cores per sock
我有一个四核(具有超线程技术- HT),我运行的应用程序需要270%的CPU (根据顶级命令)
可用CPU的总使用量是多少?(是400%还是800%?)
- I'm asking because according to Intel documentation, the HT can up the performance up to 30% cpu, so 800% seem to much, yeah?)
负载平均值和CPU使用率之间的关系是什么?
我正在编写一个小小的python脚本来测试一些东西。稍后,我想使用它创建资源使用图,但首先要进行几个测试。
剧本看上去像
import subprocess
result = subprocess.check_output("top -b -n 1 -c", shell=True).split("\n")
head = result[:5]
body = [x for x in result[7:] if x] #removes empty strings
for line in head:
print line
csum = 0.0
for l