Post reply

64bit OS 32bit SQL Server 2005 Memory!?

  • May 18, 2011 at 5:50 am

    #240419

    Hi all,

    so i found out we have a box that has Windows 2008 r2 64bit installed with SQL Server 2005 32bit on top.

    doing a quick and dirty Resource Monitor. It shows SQL taking up nearly 4gb. (We have 12gb installed)

    How can i get SQL to grab more memory. I know you enable AWE but im unsure if i need to do all the boot.ini changes im guessing not since its 64bit os?

    Any help greatly appreciated

    S

  • May 18, 2011 at 7:02 am

    #1326409

    32 bit SQL will utilize only max 4gb of RAM if you dint enable AWE, you have to enable AWE to use more memory for SQL server, No need to change any settings in boot.ini since the OS is 64 bit, it is better to enable page lock option in group policy

  • May 18, 2011 at 8:38 am

    #1326505

    Ok,

    So i changed the account that runs SQLServer, SQLAgent to the AD account we use.

    Then Added the use to the Lock Pages in Memory.

    Then open SSMS right click on the DB and go to Properties -> Memory -> Ticked Enable AWE and set Max to 10gb min to 2gb

    Anyway to test its working or there any steps ive missed out?

    S

  • May 18, 2011 at 8:23 pm

    #1326873

    for better understanding this you can enable counters and observe the changes,

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

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