SQL语句实现查询SQL Server内存使用状况
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
热门推荐
10 正月十五简短谜语祝福语
11 简短浪漫的生日祝福语
12 乔迁送茶具简短祝福语
13 送礼祝福语简短有深意
14 简短生日祝福语女朋友
15 拜年同事祝福语大全简短
16 团队虎年祝福语简短霸气
17 高寿生日祝福语简短独特
18 滑稽搞笑结婚祝福语简短