Go Premium for a chance to win a PS4. Enter to Win

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 197
  • Last Modified:

SQL Server memory Issue

Hi Experts,

As per the below screenshots SQL Server service has occupied the 28 GB space out of 32 GB.

How could I fix it to as less as possible?

Requesting your help...

D Patel
D Patel
D Patel
2 Solutions
Radhakrishnan RITCommented:
Which process is consuming more memory?  Open process tab and find out,  if it's sqldb then you can limit the memory using Sql management studio.
Nakul VachhrajaniTechnical Architect, Capgemini IndiaCommented:
In your case, you have two instances on the same machine which makes troubleshooting a challenge.

Under normal circumstances, it is quite okay for SQL Server to occupy memory so that it can cache as many execution plans and as it can into the memory and so for the buffer pool as well. The more SQL Server has to swap to disk, the slower your server will perform. What is the problem you are facing? In other words, why do you think high memory consumption is a problem on your server?

One more thing - do you have Max. memory configuration set on this server? Typically if the available physical RAM is > 8GB, you should reserve 8GB RAM for the OS and the rest should be available to SQL Server. In this case, the server with heavier load should get the larger share of the remaining 24GB (maybe a 14GB/10GB split).
D PatelD Patel, Software EngineerAuthor Commented:
@Radhakrishnan Rajayyan
sqlservr.exe taking more space (its 18 GB).

@Nakul Vachhrajani
I have 32 GB installed on my server.

How could I reserve 8 GB space for the OS?

Please let me know the setting up process...

D Patel
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Nakul VachhrajaniTechnical Architect, Capgemini IndiaCommented:
Yes. Not only should you leave 8 GB for the OS, you should also set the max. memory setting on your SQL Servers (both instances) such that they do not compete with each other (you can use a split of the remaining memory as I suggested - 14GB to one instance and 10GB to another). Here's a TechNet page that will show you how to set the memory configuration: https://technet.microsoft.com/en-us/library/ms191144(v=sql.105).aspx

The more important questions are - why do you think this is too much memory being consumed? Are you facing a performance problem? Why are you running 2 SQL Server instances on the same hardware?
yo_beeDirector of ITCommented:
The info that Nakul Vachhrajani supplied is the way to go.  Just an FYI on MS SQL.  If will use almost all the spare memory if not set to a max limit like 6 GB.  So if you have 6 to 32 GB worth of memory it will use it.  So if you where thinking if adding memory would solve this, it will not give you more free memory space, but give SQL more buffer.
Pawan KumarDatabase ExpertCommented:
Just few additions to the information shared by other experts-

1. Quick fix will be restart the server.

2. Consuming all memory is the default behavior of SQL SERVER. If you dont specify min and max server memory configuration then SQL SERVER will consume all the memory available. It is by DESIGN.

<<For below settings you must consult your Infra Team.>>
3. Setting MIN and MAX Server memory. <<Use article for configuration settings>> https://support.microsoft.com/en-us/kb/319942

4. Max memory limits only Buffer Pool size. It does not limit unreserved memory.

Read how much memory your SQL needs- http://www.sqlskills.com/blogs/jonathan/how-much-memory-does-my-sql-server-actually-need/

Hope it helps !!
D PatelD Patel, Software EngineerAuthor Commented:
Thank you for your help

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now