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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Performance Tuning » sql server 2005 (std edition 32 bits) on...

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

Rate Topic

Display Mode

Topic Options

Author

Message

chewychewy

Posted Tuesday, March 12, 2013 3:05 AM

Valued Member

Group: General Forum Members
Last Login: 2 days ago @ 9:47 PM
Points: 72, Visits: 287

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

GilaMonster

Posted Tuesday, March 12, 2013 4:18 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:23 AM
Points: 37,738, Visits: 30,009

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

EdVassie

Posted Wednesday, March 13, 2013 3:41 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 3:26 AM
Points: 2,621, Visits: 2,759

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.

Author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2012, 2008 R2, 2008 and 2005. 25 March 2013: now over 23,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

chewychewy

Posted Monday, March 18, 2013 11:56 PM

Valued Member

Group: General Forum Members
Last Login: 2 days ago @ 9:47 PM
Points: 72, Visits: 287

thanks all

Post #1432475

« Prev Topic | Next Topic »

Permissions