The database server that I am using is running 6 different SQL Server instances. It has 48 GB RAM. And one of them is consuming more than 10 GB of RAM, total consumption is 20 GB for now. The RAM consumption is growing continuously. Couple of days before it was using more than 40 GB of RAM and the server was responding very slow. The application shows the crashing problems when saving data.
So I restarted the SQL Server services.
As soon as the services were restarted, the usage came down to 4 GB, but now it is growing. And I am worried that it will grow up to 40 GB in 4 or 5 days and make the server slow.
Service restarting is not the good option I guess.
I also found from different sources that we can set the maximum memory usage size for SQL Server. And am not quite sure if this will help or not. I can't test this because the server is using the production database and it would be a risk if the service stops while modifying the setting in SQL Server.
Can any one help for this problem?