I am noticing on VPS that SQL Server is taking more memory and not releasing memory even when there is no much activity. Is there any method so I can release memory when it is not required,. Either by setting with SQL Server or by programming.
I used memory limit of sql server, but it created problem. I am not willing to go with memory limit.