Post reply

SQL Enterprise Edition only using 2G of RAM

  • November 3, 2006 at 3:44 pm

    #61976

    We just upgraded to Enterprise Edition, but it appears that the server is still only using 2 Gig of RAM. I have the server memory properties set to use 15 G max.  Did I miss some other required setting to get it to utilize the memory ?

  • November 3, 2006 at 4:00 pm

    #669934

    You need to apply the latest service pack and hot fix.

  • November 3, 2006 at 4:07 pm

    #669935

    Did you enable AWE?  Did you set the /PAE and /3GB switches in the boot.ini file?  Does the windows account that SQL Server is running under have the 'Lock pages in memory' policy assigned to it?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • November 3, 2006 at 7:11 pm

    #669944

    this is a joke, right?  lol

    hasn't the "trainee developer" answered this one?  I wonder if he's training to be a developer, or if he develops trainees?

    Have a great weekend!  I'm going for beer!

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

  • November 4, 2006 at 12:23 am

    #669954

    I was missing /PAE ...  Thanks !

    (I missed the joke)

  • November 8, 2006 at 5:48 am

    #670534

    Where is the boot.ini file?

    Ok stupid question ...

     

    multi(0)disk(0)rdisk(0)partition(2)\WINDOWS="Windows Server 2003, Enterprise" /fastdetect /PAE /NoExecute=OptOut

     

    Ok so do I need other switches aswell???

     

     

  • November 8, 2006 at 5:50 am

    #670536

    its on C:

    goto view and change the option not to hide protected Os files.

    cheers

    Kindest Regards,

    John Burchel (Trainee Developer)

  • November 8, 2006 at 6:44 am

    #670550

    I've added the /3GB SWITCH not sure it did anything.

    Thanks

    will

  • November 8, 2006 at 7:15 am

    #670563

    Wooohooo it worked. All that lovely memory chewed up

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply