Full text 4Gb memory

I have a server run std edition 2000 with FTS. The server has 4Gb of memory
is there any benefit in setting the 3Gb switch?The /3GB switch refers to the Virtual Address Space for any process, not
just SQL Server. Whether or not that space is backed by physical ram is
dependent on the configuration of the server and other applications running
at any particular time. Let's say you have 2 GB of ram and a 4 GB swap
file. Then, it is possible for an application to have, say 1 GB of physical
ram for kernel mode processing, 1 GB of physical ram for a portion of the
user mode processing, then the application could use of to 2 GB of swap
space. The allocation of that swap space would be dependent on the /3GB
switch being enabled or not.
The same goes for physical ram. If you have 4 GB, then it is possible that
one application could be allocated 1 GB for kernel mode, and 3 GB for user
mode. The problem is that this is not the only application on the server.
If anything, the OS has to be running, mostly from critical sections of
physical ram.
Now, SQL Server 2K Standard Edition will only allocate a MAXIMUM of 2 GB for
the Buffer Pool. As SS2K SE is an application, it could use 1 GB to 2 GB
for the kernel mode requests, but the Buffer Pool is not the ONLY space SS
uses. So, by using the /3GB switch, you could dedicate a 2 GB Buffer Pool
and still allow up to 1 GB for kernel mode requests and 1 GB for MEM TO
LEAVE sections of memory, all backed by physical ram. To the extent that
other applications and the OS itself requires physical ram, you could still
maintain a 2 GB Buffer Pool backed by physical ram and allow the kernel mode
and MEM TO LEAVE regions to be swapped out to the page file.
So, yes, there could be benefits to using the /3GB switch.
However, you never said what OS version you were running on. Neither Win2K
SE nor Win2K3 SE support the /3GB boot.ini parameter. You have to be
running Win2K AS or Win2K3 EE or either of the Data Center Editions.
Sincerely,
Anthony Thomas
"Simon" <Simon@.cmg.noemail> wrote in message
news:07DDD724-0C42-4748-A82F-5C41DE2AD5D4@.microsoft.com...
I have a server run std edition 2000 with FTS. The server has 4Gb of memory
is there any benefit in setting the 3Gb switch?