Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
franco
Constraint Violating Yak Guru
255 Posts |
 Posted - 2009-02-02 : 07:36:30
|
| Dear all, I know that this topic has been discussed before but again I need some light on this subject.Our environment:Windows Server 2003 Enterprise Edition 32bit architecture.Intel Xeon processor PAE capable.SQL Server 2000 Enterprise Edition 32bit version.For what I have understood i don't need to put /PAE switch on the boot.ini because on "System Properties", General tab, I see 16GB memory available with Phisical Address Extension.I set SQL Server with "max server memory" up to 3GB because there are other applications running on the server.I notice that only 1.5GB is used by SQL Server and I just want to know if this is because that's the amount SQL Server use and therefore that's ok, or if I need to set "AWE advanced option" to 1 in order to let SQL Server grab 3GB of memory.In other words what can I accomplish to give to SQL Server 3 or 4 GB of physical RAM?Please advise.Kind regards.Franco |
|
|
heavymind
Posting Yak Master
115 Posts |
Posted - 2009-02-02 : 09:13:30
|
| If sql server uses 1GB of memory with max server memory 3GB that means it does not need more. Try to set min server memory to see the limits.Actually sql server 2000 Enterprise edition can consume up to 2 GB (actually ~1.8GB) of memory as any other windows process without /PAE /AWE options. If you want sql server to use more than 3GB you definitely need to enable /AWE on your operating system and sql server itselfThanks, VadymMCITP DBA 2005/2008Chief DBA at http://www.db-staff.com |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-02 : 09:24:44
|
| Why SQL Server is limited to only 3 GB despite the fact that you have 16 GB in your box? |
|
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2009-02-02 : 10:24:59
|
| Vadym, thank you for you reply.Sodeep, I have explained in my post, that's because there are other heavy application running in this server that is a node of a cluster.So I have to take in count how many memory this server will have left if the other node fails.Franco |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-02 : 17:07:21
|
| /3GB switch can used to grab 3 GB memory. |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2009-02-03 : 10:23:21
|
| And the account running SQL needs to have "lock pages in memory" rights granted to it. Check the SQL server log to ensure Awe is in effect, it'll appear after the startup of SQL messages within the log.Terry-- Procrastinate now! |
|
|
|
|
|
|
SQL Server 2000 EE memory