AnsweredAssumed Answered

SQL Server RAM increases when service called

Question asked by crookcountygis on Feb 13, 2019
Latest reply on Feb 13, 2019 by crookcountygis

Hello,

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.

 

  1. Is this a common issue?
  2. What exactly is happening that causes the increase to the RAM?
  3. What is the best practice in keeping the RAM down? Or do we just need to restart the machine regularly?

 

Thanks

Outcomes