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;
[SQLServer] 内存占用查看
推荐阅读
- Java实现验证码的产生和验证
- java23种设计模式
- 启动elasticsearch出现java.io.FileNotFoundException一系列异常
- 启动xShell时,出现msvcp110.dll、msvcr110.dll、mfc110.dll丢失
- Linux安装Redis后,make test出现You need tcl 8.5 or newer in order to run the Redis test”问题
- jdbc操作hive出现连接拒绝
- springboot的war包在外部的tomcat发布出现org.apache.catalina.LifecycleException: Failed to start component
- TNS:listener could not find available handler with matching protocol stack
- 不能在 UTF8 和 UCS2 之间转换: failUTF8Conv
- Js企业面试题