查看内存占用

来源：互联网发布：林彪为什么出逃知乎编辑：程序博客网时间：2024/06/06 01:37
--参考：https://msdn.microsoft.com/zh-cn/library/ms175019.aspx--查看 2012,2014+ 内存占用SELECT  M.type ,        SUM(M.virtual_memory_reserved_kb)/1024 AS VirtualMemoryReservedMB ,--保留的虚拟内存量        SUM(M.virtual_memory_committed_kb)/1024 AS VirtualMemortCommitedMB ,--提交的虚拟内存量        SUM(M.shared_memory_committed_kb)/1024 AS SharedMemroyCommittedMB ,--提交的共享内存量        SUM(M.shared_memory_reserved_kb)/1024 AS SharedMemroyReservedMB ,--保留的共享内存量        SUM(M.pages_kb)/1024 AS TotalPagesMBFROM    sys.dm_os_memory_clerks MGROUP BY M.typeORDER BY TotalPagesMB DESC--查看 2005,2008 内存占用SELECT  M.type ,        SUM(M.virtual_memory_reserved_kb)/1024 AS VirtualMemoryReservedMB ,        SUM(M.virtual_memory_committed_kb)/1024 AS VirtualMemortCommitedMB ,        SUM(M.shared_memory_committed_kb)/1024 AS SharedMemroyCommittedMB ,        SUM(M.shared_memory_reserved_kb)/1024 AS SharedMemroyReservedMB ,        SUM(M.multi_pages_kb)/1024 AS MultiPagesMB ,        SUM(M.single_pages_kb)/1024 AS SinglePagesMB ,        SUM(M.multi_pages_kb)/1024 + SUM(M.single_pages_kb)/1024 AS TotalPagesMBFROM    sys.dm_os_memory_clerks MGROUP BY M.typeORDER BY TotalPagesMB DESC
0 0