请大神们指教为什么我64位的服务器上查出来的“数据页面缓存”竟然会存在awe_allocated_kb,而且会不断的持续增大,如果不重启sql server服务,此值会一直增大,直到把服务器内存几乎占光。
select
type,
SUM(virtual_memory_reserved_kb) as VM_Reserved,
SUM(virtual_memory_committed_kb) as VM_Committed,
SUM(awe_allocated_kb) as AWE_Allocated, SUM(shared_memory_reserved_kb) as SM_Reserved,
SUM(shared_memory_committed_kb) as SM_Committed,
SUM(multi_pages_kb) as Multipage_Allocator,
SUM(single_pages_kb) as SinlgePage_Allocator
From sys.dm_os_memory_clerks
where type='MEMORYCLERK_SQLBUFFERPOOL'
group by type
附截图,就是其中红色部分得出的结果会持续不断的增加,按照常理64位系统是不支持AWE的,并且我也确实查了,我的服务器并没有开启AWE选项。求大神指点。