I've noticed that the RAM associated with our SQL Server increases each time a web service referencing data in the SQL Server is queried. When we restart the machine SQL Server starts out only using a couple hundred mb's of RAM. Each query adds about 2-3 mb's to the RAM. Overtime this will cause SQL Server to consume gigs of RAM. This morning it was at 16 gb's of RAM. I have a few questions regarding this.
- Is this a common issue?
- What exactly is happening that causes the increase to the RAM?
- What is the best practice in keeping the RAM down? Or do we just need to restart the machine regularly?