/AWE - /PAE switches

  • Just a little bit confused on this topic.

    Environment:

    SQL Server 2000 Enterprise edition.

    Windows 2000 Advanced server.

    4 GB RAM.

    I am thinking to do this actions so I ask you to please advise if you think this is a correct approach:

    Add on the BOOT.ini file the /3GB switch alone,not the /PAE switch.

    sp_configure 'show advanced option' ,1

    reconfigure

    go

    sp_configure 'awe enabled' ,1

    reconfigure

    go

    sp_configure 'max server memory', 3072 (here I have a little doubt!)

    reconfigure

    go

    so_configure 'min memory', 1024 (here I have a lots of doubts!)

    reconfigure

    go

    reboot server

    Thank you for your time.

    Kind regards.

    Franco

    Franco


    Franco

  • Not sure if this answer your question, but check the article posted by Joseph Sack http://www.sqlservercentral.com/columnists/jsack/aweadventures.asp

  • You need only /3GB in your boot.ini file. Enabling AWE in SQL Server doesn't have any effect because your server has only 4GB memory.

    I would let SQL Server to dynamically adjust memory allocation by set "min server memory (MB)" to 0 and "max server memory (MB)" to maximum memory you have.

Viewing 3 posts - 1 through 2 (of 2 total)

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