Microsoft SQL Server memory utilization

1.4k views Asked by At

I'm confused about memory utilization of SQL Server. Before migration I've been using 2GB RAM and memory usage was a 1.87GB. After I migrated my server with 16GB physical memory. But it's not approximately 1.87GB it will be 5Gb or higher than. SQL Server data hasn't changed.

Here is memory usage of my current server. Do you have any idea about this? PLS

enter image description here

enter image description here

1

There are 1 answers

2
sisve On

It uses more memory because it can. It's used for caching purposes; indexes, query plans, data.

You can limit the memory usage in the Server Memory Server Configuration Options