AWE and limiting below 4GB SQL Server Memory Allocation

We are running W2K Advanced Server with SQL Server
Enterprise Edition. Problem is SQL Server takes almost
all of the memory 7.8GB of 8GB and Peoplesoft application
pages like crazy. Anyway, is there a way to limit the
below 4GB SQL Server memory and use all of the above 4GB
limit? Peoplesoft can't address the above 4GB line. The
real soluition is getting the !#@.$ application off of the
server. But I can't do that right now. Is there a patch
or some way to limit the below 4GB SQL Server memory to
say 2GB and let it have all 4GB above the 4GB line?You cannot tell sql server to use what memory area. You
should set the max memory for sql server to 4gb in sql
enterprise manager. At startup sql server will grab the
first 4gb of memory. So, configure sql server in service
control manager to start manually. Start the Peoplesoft
application first so that it will get the memory it needs.
Then start the sql server and it will grab 4gb of memory
out of available memory. SQL server will lock that memory
and won't dynamically release/acquire memory as it needs
(this is a feature of AWE).
This isn't perfect solution, but you will survive.
>--Original Message--
>We are running W2K Advanced Server with SQL Server
>Enterprise Edition. Problem is SQL Server takes almost
>all of the memory 7.8GB of 8GB and Peoplesoft application
>pages like crazy. Anyway, is there a way to limit the
>below 4GB SQL Server memory and use all of the above 4GB
>limit? Peoplesoft can't address the above 4GB line. The
>real soluition is getting the !#@.$ application off of the
>server. But I can't do that right now. Is there a patch
>or some way to limit the below 4GB SQL Server memory to
>say 2GB and let it have all 4GB above the 4GB line?
>.
>