/AWE - /PAE switches - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

/AWE - /PAE switches

Author

Topic

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2003-04-18 : 05:06:40

Just a little bit confused on this topic.
Environment:
SQL Server 2000 Enterprise edition.
Windows 2000 Advanced server.
4 GB RAM.

I am thinking to do this actions so I ask you to please advise if you think this is a correct approach:

Add on the BOOT.ini file the /3GB switch alone,not the /PAE switch.

sp_configure 'show advanced option' ,1
reconfigure
go
sp_configure 'awe enabled' ,1
reconfigure
go
sp_configure 'max server memory', 3072 (here I have a little doubt!)
reconfigure
go
so_configure 'min memory', 1024 (here I have a lots of doubts!)
reconfigure
go

reboot server

Thank you for your time.
Kind regards.

Franco

Franco

nr
SQLTeam MVY

12543 Posts

Posted - 2003-04-18 : 07:37:03

Why do you feel you need to do anything?

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2003-04-18 : 07:57:14

I don't understand your question.

Franco

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2003-04-18 : 08:51:27

This looks familiar

Repost of the reply from sqlserver.server

Since you only want to give SQL 3 GB RAM, you just need
the /3GB switch, you don't need to enable AWE (it has overhead
associated with it plus you loose the ability for SQL to dynamically
manage memory. In the example you give, SQL will take the 3 GB
at startup with AWE enabled effectively ignoring the min server memory
setting). You certainly don't need /PAE as that is required to access
memory >4GB. So you have 2 options , either use /3GB switch in
boot.ini and let SQL sort the memory out, or enamble AWE and
set a fixed amount of memory (in which case you could squeze 3.5 GB
out of the server for SQL )

HTH
Jasper Smith

0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2003-04-18 : 08:51:27

Hmm it seemed to post the reply twice

Edited by - jasper_smith on 04/18/2003 08:52:31

nr
SQLTeam MVY

12543 Posts

Posted - 2003-04-18 : 09:02:53

The /3GB switch might be a good idea to have the os only reserve 1 GB.

Don't think you would need awe or min/max memory set.

If you were to do this then probably set min and max memory to the same to have it fixed.
Don't see how pae would help.
Try it and see.

Also try without any settings - depends what else you have running on the server.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2003-04-18 : 09:15:07

Jasper Smith:
Thank you for your answer.
It's really looks familiar

eh eh eh ...
nr:
Thank you for your advice.

Franco

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources