SQL Server Performance
  1. silktaiji New Member

    I have a server with 8GB physical memory, and I wanted to expand the memory from 2GB(default) to 6GB using AWE, so I did this:

    1. added /PAE in boot.ini

    sp_configure 'show advanced options', 1
    sp_configure 'awe enabled', 1
    sp_configure 'max server memory', 6144
    RECONFIGURE with override

    3. shut down and restarted SQL Server

    When I run

    exec sp_configure 'max server memory (MB)'

    It returns -

    Name Min Max Configure_value Run_value
    max server memory (MB)421474836476144 6144

    And, it appears that Max server memory is still 2GB rather than 6GB that I requested. However, Configure and Run values are all 6GB. What do these two value mean? Should Max show 6GB instead of 2147483647.

    What did I do wrong in this setting?

    Any input would be greatly appreciated. Thank you very much.

  2. MohammedU New Member

  3. Luis Martin Moderator

    I´ve locked.

    Luis Martin

    All in Love is Fair
    Stevie Wonder

    All postings are provided “AS IS” with no warranties for accuracy.

Share This Page