Post reply

sql server 2005 (std edition 32 bits) on windows server 2003 enterprise 32 bits

  • March 12, 2013 at 3:05 am

    #290620

    Hi Guys,

    I have 8GB RAM on windows server 2003 enterprise 32 bits. From my computer, right click properties I can see 8GB.

    However, i notice that my db instance can only use up to 1.6GB. (I didn't set max memory setting).

    In order for my sql server 2005 (std edition 32 bits) instance to use more than 1.6GB memory, I understand that I will need to enable lock pages memory for the db service account and enable AWE in sql server.

    However, do i need to add /PAE to my below boot.ini as well? What is the diff between /PAE and /3GB?

    thanks!

    [boot loader]

    timeout=30

    default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS

    [operating systems]

    multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Enterprise" /fastdetect /noexecute=optout

  • March 12, 2013 at 4:18 am

    #1595885

    Add /PAE to the boot.ini. Grant locked pages, enable AWE.

    /PAE - allow memory usage above 4GB (32 bit limit)

    /3GB - change the kernal/user memory division from 2GB/2GB to 1GB/3GB.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 13, 2013 at 3:41 am

    #1596396

    You might like to look at http://sqlserverfinebuild.codeplex.com/wikipage?title=SQL%20Server%20AWE%20Property for more details of how the AWE property works.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

  • March 18, 2013 at 11:56 pm

    #1598292

    thanks all

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

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