SQL Server Performance

PAE Switch

Discussion in 'Performance Tuning for Hardware Configurations' started by silktaiji, Mar 12, 2007.

  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
    2.

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

    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.







    silktaiji, Mar 12, 2007
    #2

  2. MohammedU New Member

    MohammedU, Mar 12, 2007
    #2

  3. Luis Martin Moderator

    I´ve locked.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


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



    Luis Martin, Mar 12, 2007
    #2

Share This Page