onlo (7/2/2008)
There were no difference between "Total Server Memory" & "Target Server Memory"However, I found both of its "Total Server Memory" & "Target Server Memory" are far below the physical memory : 214960 KB - 605368 KB.
How can we increase these 2 values ?
Do I need to modify the boot.ini file by adding : /3GB ?
Or sp_configure ‘awe enabled’, 1 ?
Please give me advices. Thanks.
Total memory should always ideally be less than target memory.
you dont need AWE enabled with under 4GB RAM, so leave that alone.
It may be worth using the /3GB switch in the boot.ini (you could certainly try it).
As already mentioned what do the other counters show?
Balmukund Lakhani (7/2/2008)
set min and max server memory to around 2 GB.
always ensure that min memory is less than max memory never the same or higher
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉