Post reply

AWE Enable

  • May 3, 2005 at 12:12 pm

    #102508

    We have Windows 2003 Advanced Server and MS SQL Server 2000 SP3a. My Boot.ini says "/3GB /PAE" and on SQL server I have "AWE Enable" to 1.

    I have 7GB of RAM available on that box with 4 instances. Here is how I am trying to set max server memory limit  per instance:

    Server/Inst1    -   2.5G

    Server/Inst2    -  1.5G

    Server/Inst3   - 1 GB

    Server/Inst4   - 1 GB

    I know when we enable AWE option sql server will not be able to dynamically allocate memory . Hence I am trying to set max server memory limit so that everybody can live happily.

    Please let me know if what I am doing is correct. Or should I make it 6GB each and let the SQL server handle it ?  Will this cause any "insufficient memory" errors ?

    Any help in this context is appreciated.

    Thanks.

  • May 3, 2005 at 12:31 pm

    #556600

    I would do exactly as you have mentioned above. Set the max memory for each instance, otherwise you'll end up with one instance taking all the memory leaving nothing for the others.


    Shamless self promotion - read my blog http://sirsql.net

  • May 4, 2005 at 7:48 am

    #556763

    Have been researching this a little myself too and was under the impression you needed SQL Server Ent Edition to use AWE. 

    Are you using Ent Edition ? Have you checked using Task Manager or Windows Perf monitor that the memory has been allocated as requested.

    Thanks

     

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

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