Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sql server 2005 (std edition 32 bits) on windows server 2003 enterprise 32 bits Expand / Collapse
Author
Message
Posted Tuesday, March 12, 2013 3:05 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 8:38 AM
Points: 91, Visits: 391
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
Post #1429622
Posted Tuesday, March 12, 2013 4:18 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 11:47 AM
Points: 41,525, Visits: 34,442
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 2008, MVP
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

Post #1429660
Posted Wednesday, March 13, 2013 3:41 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, April 14, 2014 3:21 AM
Points: 2,797, Visits: 3,079
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: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 25 March 2014: now over 28,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1430267
Posted Monday, March 18, 2013 11:56 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 8:38 AM
Points: 91, Visits: 391
thanks all
Post #1432475
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse