Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

We have a Windows 2008 R2 on a HP Server with 24GB of RAM. The only important software installed is SQL Server 2008 R2 and almost no feature or role is enabled on this Windows.

But the problem is that always RAM is almost full. When we look at performance in Task Manager or memory part of Resource Monitor or third party programs, we see that about 97%-99% of 24GB RAM is occupied but summation of all processes' used memory is something less than 1GB.

If this percentage of RAM is used, why windows can not show what processes are using this amount of memory? and if not, why windows says that RAM is full?

share|improve this question

3 Answers 3

SQL Server uses all the memory available. It's not a bug, it's by design. That's also why SQL Server must be installed on dedicated machines (and not together with IIS for example).

When running for a long time, SQL Server stores the data according to the executed queries, so that they are faster to execute later. This means that when you start the server, the memory usage will be low, but will grow over time.

You can adjust the memory limit to use by SQL Server, but you shouldn't do that unless you have serious reasons for it.

Here is a quote from How to adjust memory usage by using configuration options in SQL Server on Microsoft Support website:

When you start SQL Server, SQL Server memory usage may continue to steadily increase and not decrease, even when activity on the server is low. Additionally, the Task Manager and Performance Monitor may show that the physical memory available on the computer is steadily decreasing until the available memory is between 4 to 10 MB.

This behavior alone does not indicate a memory leak. This behavior is normal and is an intended behavior of the SQL Server buffer pool.

share|improve this answer

You can use RAMMap to find out what process is using your memory (and how).

share|improve this answer

To specify the maximal and minimal amount of memory that SQL Serve ruses:

  1. Right-click the SQL Server instance in SQL Server Management Studio Object Explorer
  2. Select Properties
  3. Select the Memory tab

enter image description here

For more info, see this article: Effects of min and max server memory

As for the memory allocation per specific process, you can start with Windows Resource Monitor

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.