| Tomski 2002-11-28, 7:23 pm |
| This is straight out of SQL BOL..
To enable Windows 2000 Advanced Server or Windows 2000
Datacenter Server to support more than 4 GB of physical
memory, you must add the /pae parameter to the boot.ini
file.
To enable Windows 2000 Advanced Server and Windows 2000
Datacenter Server to support a 3-GB virtual address space,
you must add the /3gb parameter to the boot.ini file. This
allows user applications to address 3 GB of virtual memory
and reserves 1 GB of virtual memory for the operating
system.
However, if there is more than 16 GB of physical memory
available on a computer, Windows 2000 needs 2 GB of
virtual memory address space for system purposes and
therefore can support only a 2-GB virtual address space
Cheers
Tomski
>-----Original Message-----
>I have 2.5GB of RAM for SQL2000 and SQL server never
>crosses 1.7GB for some reason. I have tried sp_configure
>for enabling AWE. This does not help. Windoes 2000 Server
>is the OS. And the RAM is recognised by OS.
>
>Any clue how i could make SQL to use up the full RAM?.
>
>Thank You
>N.Raja
>.
>
|