Post reply

Reset to default memory disabling awe

  • June 7, 2006 at 6:57 am

    #113372

    I was wondering if there is way to go back to default memory setting of sql server and disable awe so that sql server can dynamically allocate memory?

     

    thanks

  • June 8, 2006 at 9:48 am

    #642577

    You should be able to reverse the process that was used to enable AWE in the first place.

    1. Remove the /3GB switch in the Boot.ini file

    2. Reconfigure AWE switch:

    sp_configure 'show advanced options', 1

    RECONFIGURE

    GO

    sp_configure 'awe enabled', 0

    RECONFIGURE

    GO

    3. Set SQL Server Properties (Memory Tab) to dynamically configure SQL Server Memory.

    Reboot and you should be good to go......

  • June 8, 2006 at 9:51 am

    #642578

    in this case i dont have /3gb flag in boot.ini file. only /pae flag.

  • June 9, 2006 at 12:07 pm

    #642880

    also if I disable AWE, does SQL Server needs to restarted?

  • June 13, 2006 at 6:27 am

    #643340

    Have not done it but parameters changed by an sp_configure do not need a restart of sql server

     

     

    Mike

  • June 14, 2006 at 9:09 pm

    #643851

    but you may need to issue a RECONFIGURE WITH OVERRIDE statement.

    EG - to set some ANSI defaults on SQL and have it apply straight away

    exec sp_configure N'user options', 376

    GO

    RECONFIGURE WITH OVERRIDE

    GO

     

Viewing 6 posts - 1 through 5 (of 5 total)

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