Wednesday, March 7, 2012

AWE Enabled + Security Settings set but still no memory increase?

Hi,
If anyone has come across a similar issue, any help would
be appreciated . We have a WIN2k3 Server (not advanced)
running SQL 2k Enterprise. We have installed an
additional 2gb worth of memory ramping it up to 4gb. We
have set up AWE enabled settings on SQL 2k and adjusted
the local security settings. Problem is that we never
get above 2gb on our memory usage? Can someone explain
why this is happening and maybe highlight something that
I have missed? The reason for installing the additional
memory was to reduce dts loads and sql qry times that hit
2gb memory capacity on a daily basis?!?! Why doesnt sql
use the additional 2gb?!!
Thanks in advance
PaulI presume you have increased the maximum amount of memory SQL Server can use
(Enterprise manages, right click server, properties, memory)? Does it
recognise there is now 4gb in the machine?
"Paul" <ptel4d@.hotmail.com> wrote in message
news:073701c351bd$5eee7320$a601280a@.phx.gbl...
> Hi,
> If anyone has come across a similar issue, any help would
> be appreciated . We have a WIN2k3 Server (not advanced)
> running SQL 2k Enterprise. We have installed an
> additional 2gb worth of memory ramping it up to 4gb. We
> have set up AWE enabled settings on SQL 2k and adjusted
> the local security settings. Problem is that we never
> get above 2gb on our memory usage? Can someone explain
> why this is happening and maybe highlight something that
> I have missed? The reason for installing the additional
> memory was to reduce dts loads and sql qry times that hit
> 2gb memory capacity on a daily basis?!?! Why doesnt sql
> use the additional 2gb?!!
> Thanks in advance
> Paul

No comments:

Post a Comment