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

Does the "Free" Memory matter in SQL server?

On our SQL 2008 server, if you click Task Manager, you will see the "Physical Memory (MB)" list as the following format:
Physical Memory (MB)
Total:
Cached:
Free:  

It has come to my attention that sometimes the "Free Memory" in the above list reaches to zero. Doe it mean the memory is not sufficient and it is time for me to put more memory chips?
0
Castlewood
Asked:
Castlewood
2 Solutions
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Not really. You need to see inside SQL Server. How is configured the Minimum and Maximum Server Memory for SQL Server instance?
0
 
CastlewoodAuthor Commented:
Thank you.
I think I need to give you one more piece of info: our db size is about 12G while the total RAM memory we currently have is 16G.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
You need to give me the SQL Server memory configuration. The values I asked above.
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
CastlewoodAuthor Commented:
Here you go:
Use AWE to allocate memory is checked
Minimum: 2,048 MB
Maximum: 12,288 MB
Index creation memory:  0
Minimum memory per query: 1,024 kb
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
AWE? It's a 32 bit system? If so, I think you can't address more than 16GB so if you add more RAM it won't benefit you in nothing. You need to migrate to a 64 bit system before going on with this.
0
 
KimputerCommented:
Looking at it as a whole (as a server, not just the SQL server software part), having 0 MB free will have impact on performance. While adding memory might or might not benefit SQL Server, the Windows Server itself will still benefit, having more memory free because of other software/services (less hard disk hits, by default already means increased performance).
You can say this with 100% certainty WITHOUT knowing anything else. Of course, more details provided by you will reveal if the memory is used in a correct way, or that some memory hog/leak is causing problems.
0
 
CastlewoodAuthor Commented:
The SQL server is a x64.
So you are saying the AWE should NOT be ticked?
Other than that, did the minimum/ maximum memory say anything ?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Yes, AWE it's only for 32 bit installations.
Memory seems ok so if you're facing memory pressure than you should add more RAM. Being a x64 system will be easy to do so.
0
 
Scott PletcherSenior DBACommented:
>> It has come to my attention that sometimes the "Free Memory" in the above list reaches to zero. Doe[s] it mean the memory is not sufficient and it is time for me to put more memory chips? <<

Basically yes, unless you can do something to significantly reduce memory usage on that server.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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