查看内存占用

最新推荐文章于 2022-04-08 09:39:02 发布

吉普赛的歌

最新推荐文章于 2022-04-08 09:39:02 发布

阅读量516

点赞数

分类专栏： # 常用代码

本文链接：https://blog.csdn.net/yenange/article/details/70256874

版权

常用代码专栏收录该内容

93 篇文章 3 订阅

订阅专栏

--参考：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 TotalPagesMB
FROM    sys.dm_os_memory_clerks M
GROUP BY M.type
ORDER 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 TotalPagesMB
FROM    sys.dm_os_memory_clerks M
GROUP BY M.type
ORDER BY TotalPagesMB DESC