/3GB

I've been doing some research on whether or not to use the /3GB switch, and
/PAE, in boot.ini but seem that I find contradicting information.
This article by Brian Moran seems to indicate I should use it, and I have
the utmost respect for Brian.
http://www.sqlmag.com/Article/Artic...
of_Memory.html
But I seem to see other articles by MS that either caution against it, or
say it should only be used with certain flavors or OS. And I can't even
find my OS in any of the articles.
I'm using Windows 2003 R2, SQL 2k sp4, on a Proliant 580 with 4GB of ram.
My box is a dedicated SQL Server. I am, temporarily, running IIS and
Reporting Services on the same box. Those will be offloaded to another
server shortly.
Can anyone tell me conclusively whether or not I should use the /3GB switch?
Thanks, AndreUse the /3GB, but don't use the /PAE. Reevaluate after you move IIS and SSRS
off of the box.
Since SQL 2000 can't access memory over 3GB without /PAE, and since /PEA
requires a large memory block (up to 1GB) just to manage memory, in your
scenario, you may actually be causing a reduction to the memory available to
SQL Server.
Configuration -Enabling AWE Memory for SQL Server
http://msdn2.microsoft.com/en-us/library/ms190673.aspx
Configuration -Enabling Memory Support for Over 4 GB of Physical Memory
http://msdn2.microsoft.com/en-us/library/ms179301.aspx
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Andre" <no@.spam.com> wrote in message
news:%23DJkotWFHHA.1252@.TK2MSFTNGP02.phx.gbl...
> I've been doing some research on whether or not to use the /3GB switch,
> and /PAE, in boot.ini but seem that I find contradicting information.
> This article by Brian Moran seems to indicate I should use it, and I have
> the utmost respect for Brian.
> http://www.sqlmag.com/Article/Artic..._of_Memory.html
> But I seem to see other articles by MS that either caution against it, or
> say it should only be used with certain flavors or OS. And I can't even
> find my OS in any of the articles.
> I'm using Windows 2003 R2, SQL 2k sp4, on a Proliant 580 with 4GB of ram.
> My box is a dedicated SQL Server. I am, temporarily, running IIS and
> Reporting Services on the same box. Those will be offloaded to another
> server shortly.
> Can anyone tell me conclusively whether or not I should use the /3GB
> switch?
> Thanks, Andre
>