RAM usage is increasing in database server with time. When we restart the SQL services it take around 4 GB but after day or two it increases to 11-12 GB and even further. Application is hosted on separate server. Please suggest what could be the reason.
-
Database uses available memory to cache and for other operations.. Can you please elaborate on what specific issue / things you are looking for.. Otherwise, the question seems too general.– Vikas GuptaCommented Nov 10, 2014 at 9:29
-
Why is RAM usage even a problem?– usrCommented Nov 10, 2014 at 9:31
-
The problem is that Ram is not getting released and its a 16 GB RAM server. Once it reached to 15 GB usage and server got chocked. I need to restart the service as I left with no other option.– nakul bhardwajCommented Nov 10, 2014 at 11:53
Add a comment
|
2 Answers
SQL Server will try and use all the RAM it can get hold of to reduce execution times on queries.
As you have had it running for a day or two, with the increased amount of queries ran it will be using as much RAM that it has available to it.
Instead of trying to find a way to release your RAM, you might be better served trying to determine how much of your RAM your SQL server is allowed to use.
Seeing as how you're using a 16GB server, try leaving 2-3GB for the OS (or more depending on what else is installed on there)
The following commands would set your max server memory (the amount of memory SQL server will keep a hold of) to 12GB:
sp_configure 'max server memory', 12288;
GO
RECONFIGURE;
GO
