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 教师闺蜜祝福语简短