[SQLServer] 内存占用查看

最新推荐文章于 2024-06-21 10:14:50 发布

weixin_33941350

最新推荐文章于 2024-06-21 10:14:50 发布

阅读量207

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/lionetchen/p/6843830.html

版权

SELECT
(physical_memory_in_use_kb/1024) AS Memory_usedby_Sqlserver_MB,
(locked_page_allocations_kb/1024) AS Locked_pages_used_Sqlserver_MB,
(total_virtual_address_space_kb/1024) AS Total_VAS_in_MB,
process_physical_memory_low,
process_virtual_memory_low
FROM sys.dm_os_process_memory;

转载于:https://www.cnblogs.com/lionetchen/p/6843830.html