I have a ~45GB database that increases rapidly (~1GB every week).
So it's doing a lot of inserts; the web app doesn't have many users so reads are low right now.
But I'm noticing that the RAM sql server users goes from ~1GB when the server is first started to using ~7GB of RAM after a week.
Is there some sort of memory leak? There was an article on MSDN that suggested that the SQL server increases the memory it uses for caching and that will always continue to increase. However, the server only has 7.5GB or ram so I'm worried that it's going to run out of memory unless I restart SQL Server every week... which seems wrong.
Is this typical behavior? Is there some setting that I can set to set a cap on the memory usage?