This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 81%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMU%3C/text%3E%3C/svg%3E)
Hi, we are facing some issue related to sql server memory release. We are using sql server 2017 and above.
We have a .net application which is performing a lot of transactions on Sql server in specific use case, issue is while we are using application Sql server memory usage getting increased which is logically true, but while we are not using application or event of we stop/close application sql server memory usage is not getting decrease. I found some solution to limit its max server memory, but we don't want to do that, because at the time of need we want to use maximum memory after usage we want extra memory get released. Any one who know/face this type of issue or have knowledge about this, please let us know.
Note: if we restart sql server services or restart sql server that time memory release happened else not releasing memory.
Thanks.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 30%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETH%3C/text%3E%3C/svg%3E)
SQL Server doesn't release memory unless there is memory pressure. How would SQL Server know that nobody want to read the data is has spent so much time reading from disk into cache? SQL Server has no knowledge that you don't' intend to read those pages.
I.e., the behavior you see is by design.
Thanks TiborKaraszi for quick response, actually we are facing one more issue in our application "Not Enough Quota available to process this command". So we thought it may be related to this. Once again thanks :)
Where do you see this error, exactly?
For that specific error, I posted another question here.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
That error appears to be on the client side, not the server side. So I my first guess is the client does not have enough RAM and/or you have a memory leak somewhere in your code.
That is completely normal and expected behavior.
Please see:
Thanks TomPhillips , actually we are facing one more issue in our application "Not Enough Quota available to process this command". So we thought it may be related to this sql server memory usage.
Not Enough Quota available to process this command, is a Windows message indicating you have low memory.
The simplest thing to try first, is to reduce the SQL Server "max server memory" setting to a reasonable value. This setting must be set if you are using the server for other processes. Otherwise, SQL Server will as a default take all RAM.