Re: Seems like only 1GB RAM being used even when higher MAX RAM is

No you don't have AWE enabled but you do the the "set working set size" enabled and it should be off. Change that back to the default and you probably have to restart but I bet that will fix it.


--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Larry Epn" <larryepn@xxxxxxxxxxxxxxx> wrote in message news:79448FCB-7570-4837-B5D4-AB2195C9FE4A@xxxxxxxxxxxxxxxx
Man, you had me going for a minute, unfortunately it does not apply because
AWE is not configured on this server:
name minimum maximum config_value run_value
awe enabled 0 1 0 0

Also, this computer has 4Gb, and I am just trying to get it to use 2Gb
instead of the 1Gb it is using, so even 50% of the available memory would be
a "good thing" in my particular case. Right now it will only use 25%.

Larry



.

Relevant Pages

  • Re: Set Working Set Size / AWE
    ... It's Standard Edition, and yes, we're aware of the 2GB limit. ... That's one reason why we went with 2000MB memory setting, ... "Could not set working set size to 843776". ... >> James Hokes ...
    (microsoft.public.sqlserver.server)
  • Re: Error on log
    ... If DBCC printed error messages, ... Configuration option 'set working set size' changed from 0 to 0. ... > By anychance did you changed any memory settings of SQL server? ...
    (microsoft.public.sqlserver.setup)
  • Re: Error on log
    ... sp_configure 'set working set size' ... If the run value is not zero please ... By anychance did you changed any memory settings of SQL server? ...
    (microsoft.public.sqlserver.setup)
Loading