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 婆婆高寿祝福语大全简短