If you notice that SQL server is always hogging your memory, don’t get alarmed, that’s the way it’s meant to work. It keeps consuming memory for its buffer for as much as you permit it, even during times of low activity.
Resolution:
In your sql server management studio, you can set the maximum server memory by selecting your server properties like below.
Hope this helps.