Hello
I have server 2003 w/4gb ram and SQL2005
I have the /PAE switch in my boot.ini
how, or is it recommended to, use AWE on SQL I am new to this AWE

Since you have only 4GB, use the /3GB switch instead. You have to save some
memory for the OS.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Dan DeCoursey" <DanDeCoursey (AT) discussions (DOT) microsoft.com> wrote

Hello
I have server 2003 w/4gb ram and SQL2005
I have the /PAE switch in my boot.ini
how, or is it recommended to, use AWE on SQL I am new to this AWE

In addition to what Tom stated you don't need the /PAE switch either since
you only have 4GB.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Dan DeCoursey" <DanDeCoursey (AT) discussions (DOT) microsoft.com> wrote

I would be careful with /3GB switch because it decreases the memory reserved
for the system in 2 times - from 2 GB to 1 GB, but some buffers decrease in
more than two times. As the result the disk related and network related
operations can be significantly slowed down or they can even start failing.
Take a look at these articles, you will like them.

http://support.microsoft.com/kb/833721

http://support.microsoft.com/kb/555223

And finally these pretty new articles:

http://search.microsoft.com/results....ng=en-US&q=pae

Just D.

"Andrew J. Kelly"