Explain how to set the Total Mem Allocation using /3GB

/3GB switch is used for SQL Enterprise Ed only on Win2k Adv Server, or is it?
Can it be used to increase the Total memory allocation to a process? If so,
how is that process set?
Regards,
Jamie
the switch can be set in boot.ini on Windows 2K Adv.
Or do it using sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
Only if your Server has more than 2 GB of RAM
If you use the /PAE in Boot.ini and AWE in SQL 2000 Ent allows SQL
Server 2000 to utilize more than 4 GB memory
Without the /PAE switch SQL Server can only utilize up to 3 GB of
memory.
On Jan 22, 10:17 am, thejamie <theja...@.discussions.microsoft.com>
wrote:
> /3GB switch is used for SQL Enterprise Ed only on Win2k Adv Server, or is it?
> Can it be used to increase the Total memory allocation to a process? If so,
> how is that process set?
> --
> Regards,
> Jamie
|||/3GB is not used for SQL enterprise edition ONLY on Win2K Adv Server. You can
use it on 32-bit SQL2000/2005 enterprise edition with 32-bit Win2K/Win2K5
enterprise edition if you want the buffer pool of your SQL instance to use
more than 2GB of memory. (I only work with the enterprise editions of SQL
Server and Windows, so I can't comment on how it may behave on a
non-enterprise edition)
For some empirical data, see
http://sqlblog.com/blogs/linchi_shea/archive/2007/01/11/awe-and-3gb-an-empirical-picture.aspx.
Linchi
"thejamie" wrote:

> /3GB switch is used for SQL Enterprise Ed only on Win2k Adv Server, or is it?
> Can it be used to increase the Total memory allocation to a process? If so,
> how is that process set?
> --
> Regards,
> Jamie
|||Since it is the Standard SQL Ed, I suspect the AWE does nothing and that the
/3GB already implemented will give me the biggest bang for the buck. THere
is actually 6 GB available on the Windows Advanced Server 2000. The extra
RAM has reduced the cpu load... instead of an 80% RAM usage it is now 31%
but 31% is still, I think, just 2 GB which is as it should be.
Regards,
Jamie
"Linchi Shea" wrote:
[vbcol=seagreen]
> /3GB is not used for SQL enterprise edition ONLY on Win2K Adv Server. You can
> use it on 32-bit SQL2000/2005 enterprise edition with 32-bit Win2K/Win2K5
> enterprise edition if you want the buffer pool of your SQL instance to use
> more than 2GB of memory. (I only work with the enterprise editions of SQL
> Server and Windows, so I can't comment on how it may behave on a
> non-enterprise edition)
> For some empirical data, see
> http://sqlblog.com/blogs/linchi_shea/archive/2007/01/11/awe-and-3gb-an-empirical-picture.aspx.
> Linchi
> "thejamie" wrote: