Click here to Skip to main content
15,867,756 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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.
Posted
Updated 6-Oct-15 2:35am
v2

1 solution

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.
 
Share this answer
 
Comments
SreeDBA 6-Oct-15 8:43am    
Thanks for the reply Corporal.

Restart the prod servers was not recommended.
Corporal Agarn 6-Oct-15 8:48am    
Only the service needs restarted. However, I see your problem.
There may be a way to clear memory without a restart of the service, but I do not have that knowledge.
SreeDBA 6-Oct-15 8:50am    
OK. Thanks for reply.
Member 12003400 6-Oct-15 9:06am    
refer this
http://serverfault.com/questions/108192/how-do-i-get-sql-server-to-release-its-memory

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900