SSMS不释放系统内存 [英] SSMS not releasing system memory

问题描述

我刚开始在新办公室担任数据分析师.这项工作需要将客户端系统从我们的dbase平台升级到我们的新RDBMS.实际的转换是由一些内部软件处理的，这对我来说是一个黑匣子，但是转换结束时，我的系统内存使用量已达到16GB的〜15.3.有人告诉我只是重新启动计算机，但似乎必须有一种更好的方法(希望这不涉及修复软件，因为这对我来说是超出范围的.)

I just started at a new office as a Data Analyst. The job entails upgrading client systems from our dbase platform to our new RDBMS. The actual conversion is handled by some in-house software that is a black box to me but at the end of the conversion my system memory usage is maxed out ~15.3 of 16GB. I was told to just restart my computer but it seems like there must be a better way (hopefully that doesn't involve fixing the software since that is out of scope for me).

我在下面的链接中找到了问题，但运行DBCC DROPCLEANBUFFERS似乎不起作用.重新启动SQL实例是可行的，但是会中断实例上的所有数据库.还有其他释放内存的方法吗?

I found the question at the link below but running DBCC DROPCLEANBUFFERS doesn't seem to work. Restarting the SQL instance works but that interrupts all the databases on the instance. Is there another way to release the memory?

SQL Server清除内存

我们同时使用ssms2008r2和smss2012.

We use both ssms2008r2 and smss2012.

谢谢

推荐答案

DBCC DROPCLEANBUFFERS清除缓冲池中的所有干净缓冲区.那对你没有帮助.

DBCC DROPCLEANBUFFERS clears all the clean buffers from the buffer pool. That won't help you.

您需要了解SSMS不会占用您的内存，而sqlserver服务是. SQL Server将尽可能地扩展它的内存空间.如果您有32GB，并且您说它可以使用32GB，则它将分配尽可能多的空间.

You need to understand that SSMS isnt eating your memory, the sqlserver service is. SQL server will expand it's memory footprint as much as you will allow it. If you have 32GB and you say it can use 32GB then it will allocate as much as it can.

关于DBA堆栈交换，这是关于最大服务器内存的精彩文章:

Here's a great article on DBA stack exchange regarding max server memory: https://dba.stackexchange.com/questions/47431/why-is-sql-server-consuming-more-server-memory

这篇关于SSMS不释放系统内存的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！