SELECTtype,--Clerk的类型
sum(virtual_memory_reserved_kb)asvm_Reserved_kb,--保留的内存
sum(virtual_memory_committed_kb)asvm_Committed_kb,--提交的内存
sum(awe_allocated_kb)asawe_Allocated_kb,--开启AWE后使用的内存
sum(shared_memory_reserved_kb)assm_Reserved_kb,--共享的保留内存
sum(shared_memory_committed_kb)assm_Committed_kb,--共享的提交内存
sum(single_pages_kb)asSinlgePage_kb,--BufferPool中的Stolen的内存
sum(multi_pages_kb)asMultiPage_kb--MemToLeave的内存
FROMsys.dm_os_memory_clerks
GROUPBYtypeORDERBYtype
--查询BufferPool/MemoryToLeave
SELECT
sum(virtual_memory_reserved_kb)AS[Reserved],
sum(virtual_memory_committed_kb)AS[Commit],
sum(virtual_memory_reserved_kb)/sum(virtual_memory_committed_kb)AS[Reserved/Commit],
sum(single_pages_kb)+sum(multi_pages_kb)AS[Stolen],
sum(virtual_memory_committed_kb)+sum(single_pages_kb)AS[BufferPool],
sum(multi_pages_kb)AS[MemToLeave],
SUM(awe_allocated_kb)AS[AWEAllocated]
FROMsys.dm_os_memory_clerks
--查询SQLSERVER内存使用
select*fromsys.dm_os_process_memory
