Castlewood
asked on
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?
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?
Vitor Montalvão
Not really. You need to see inside SQL Server. How is configured the Minimum and Maximum Server Memory for SQL Server instance?
ASKER
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.
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.
You need to give me the SQL Server memory configuration. The values I asked above.
ASKER
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
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
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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 ?
So you are saying the AWE should NOT be ticked?
Other than that, did the minimum/ maximum memory say anything ?
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.