SQL服务器不释放内存 [英] SQL server not releasing memory

问题描述

我使用的是SQL 2008R2（prod服务器）。服务器总内存为20 GB。我分配了sql 14 GB并在SQL内存设置中设置了最大和最小限制。目前sql利用总内存它没有释放内存。当我试图插入数据时，由于这个原因我收到错误。目前没有活动事务，没有阻塞和死锁，所有作业都处于空闲模式。



NOte：缓冲区缓存命中率为100％



如何释放内存。重新启动SQL服务器后，它在7天后释放内存，我面临同样的问题。



在QA中使用相同的配置，但SQL在QA环境中没有使用太多内存。这些产品和质量保证有什么不同？



请帮助我们。



谢谢，

Sree。

Hi,

I am using SQL 2008R2 (prod server). Total server memory is 20 gb. I assigned for sql 14 GB and setting max and min limit in SQL memory settings. Currently the sql utilizes total memory it did not release the memory. When i am trying to insert data i am getting error due to this. Currently there is no active transaction and no blocking and dead locks & all jobs are in idle mode.

NOte : Buffer cache hit ratio is 100%

How to release the memory. After restarting the SQL server it releases memory after 7days i am facing same issue.

same configuration used in QA but SQL is not using much memory in QA environment. What is the different between those prod and QA?

Please help us.

Thanks,
Sree.

推荐答案

设置Max和Min SQL Server内存后，需要重新启动SQL Server服务。 SQL Server通常会保留所有已分配的内存。

After setting the Max and Min SQL Server memory you need to restart the SQL Server Service. SQL Server usually will keep all allocated memory.

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