Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
manwmchan
Starting Member
13 Posts |
 Posted - 2004-11-30 : 23:53:47
|
| I have a SQL server with 3GB RAM. However, I discover that it only use 1.5GB even if I have set the max memory usage of SQL server to 3GB in Enterprise manager.Would you please advise how can I force it to use all memory?Mandel ;) |
|
|
hgorijal
Constraint Violating Yak Guru
277 Posts |
Posted - 2004-12-01 : 00:36:12
|
| Unless you have instances of SQL Server 2000 running in Address Windowing Extensions (AWE) memory mode, SQL server does not utilize all the memory specified in "max server memory". It allocates it as of when needed. Do you have enough load on the server to utilize that much memory.However, it is not advisable to let SQL server use the entire RAM on the server. You need to leave enought memory for the OS and other applications to run properly. You might want to change the "max server memory" to 2 GB gor overall better performance.Hemanth GorijalaExchange a Dollar, we still have ONE each._______Exchange an Idea, we both have TWO each. |
 |
|
|
|
|
|
How to make use of all memory for SQL server