2

The situation is the following: We have a SQL2008r2 server (64bit on 64bit Windows) with SSRS installed on it. The Max Memory is set to 6GB, the server has 12GB total memory.

The target server memory is always more than the total server memory (for instance total: 2758MB, target: 6144MB = 6GB, which is the max memory).

My problem is that the server has 6GB free memory, but the SQL Server is not using the available space, nor SSRS, or other process. Can anyone tell me is this normal? I've found nothing regarding this topic online.

migrated from serverfault.com Apr 21 '15 at 22:03

This question came from our site for system and network administrators.

  • 1
    How big is your database? – David Schwartz Apr 20 '15 at 18:14
2

This is normal.

Max server memory means that your server cannot use more than that amount, not that it must use that amount. Min server memory doesn't mean it must use that amount, either; it means that once the server uses that much it doesn't surrender memory to below that amount. Basically, SQL Server uses the amount of memory it needs until it reaches the upper limit you set, and if it stops using it it might surrender part of it back unless you've set a min memory. (However, in my experience, it's pretty memory-greedy.)

In short: This means that you're currently not using 6GB of memory on your SQL Server.

  • So the target server memory will always be the max server memory? Thanks – Gábor Racskó Apr 21 '15 at 13:50
  • No, the server will always use the amount of memory it needs to do what you ask it to do, but that number will never go above max server memory. It will also not use min server memory unless it needs it, but once it reaches that amount it won't go below that until restarted. – Katherine Villyard Apr 21 '15 at 18:04
  • 1
    But it will go beyond the max setting, seen it a couple of times. This discussion is still true today: dba.stackexchange.com/questions/8374/… – Razvan Zoitanu May 11 '15 at 11:34
  • Well. Yes. I shouldn't have said "never." ;) I was oversimplifying for someone who sounded confused. But yes, you're right, it does sometimes go over that number. – Katherine Villyard May 25 '15 at 16:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy