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 PatelD Patel, Software EngineerAsked:
Who is Participating?
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?
Radhakrishnan RSenior Technical LeadCommented:
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).
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

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
yo_beeDirector of Information TechnologyCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.