how to configure SQL Server 2kEE to utilize 7 of 8GB on Win2k3

I have 8GB on a Win2k3 EE server.
I want to set aside 7GB for SQL to use. I would like to see SQL take up the
7GB on boot and hold it permanently.
I have /PAE in boot.ini, have tried with and without the /3GB -- not sure
which is required.
In SQL, I have AWE=1, and tried setting min and max memory settings to same
thing (7168). I don't see any errors on boot in APP logs or SQL logs -- but
the most I see SQL Server take up is less than 1 GB. I even tried in GUI EM
to set 'reserve physical memory for SQL Server' checkbox to on but that
didn't seem to help.
It seems most of the BOL and newsgroups comments relate how to do this with
Win2k but not Win2k3 -- any help with this is greatly appreciated.
TIA,
RobertHow are you determining the memory usage? If it is with task manager then
that is not the correct tool. User perfmon and the sql server memory
counters instead. All you should need to do is set /PAE and AWE, then MAX
Memory to 7GB and that should do what you want. Make sure the account sqls
erver is running under has lock pages in memory rights or you can't use AWE.
Andrew J. Kelly SQL MVP
"sql411@.nospam.com" <sql411@.nospam.com@.discussions.microsoft.com> wrote in
message news:F7B04CCE-116C-4536-A5FB-51FDC3367D40@.microsoft.com...
>I have 8GB on a Win2k3 EE server.
> I want to set aside 7GB for SQL to use. I would like to see SQL take up
> the
> 7GB on boot and hold it permanently.
> I have /PAE in boot.ini, have tried with and without the /3GB -- not sure
> which is required.
> In SQL, I have AWE=1, and tried setting min and max memory settings to
> same
> thing (7168). I don't see any errors on boot in APP logs or SQL logs --
> but
> the most I see SQL Server take up is less than 1 GB. I even tried in GUI
> EM
> to set 'reserve physical memory for SQL Server' checkbox to on but that
> didn't seem to help.
> It seems most of the BOL and newsgroups comments relate how to do this
> with
> Win2k but not Win2k3 -- any help with this is greatly appreciated.
> TIA,
> Robert|||Thank you, Andrew...
I am using perfmon\process\working set\sqlservr.exe at it shows basically
the same thing as task mgr.
I have did check memory/commited bytes and see that the amount committed is
equal to what I would expect SQL + the OS and other things to be. How can I
verify that SQL Server has 7GB locked in?
"Andrew J. Kelly" wrote:

> How are you determining the memory usage? If it is with task manager then
> that is not the correct tool. User perfmon and the sql server memory
> counters instead. All you should need to do is set /PAE and AWE, then MAX
> Memory to 7GB and that should do what you want. Make sure the account sql
s
> erver is running under has lock pages in memory rights or you can't use AW
E.
> --
> Andrew J. Kelly SQL MVP
>
> "sql411@.nospam.com" <sql411@.nospam.com@.discussions.microsoft.com> wrote in
> message news:F7B04CCE-116C-4536-A5FB-51FDC3367D40@.microsoft.com...
>
>|||The memory that SQL Server uses once AWE is enabled is fixed and no longer
dynamic. The SQL Server Target and Total memory counters are both at the
max you set the memory to you are there.
Andrew J. Kelly SQL MVP
"sql411@.nospam.com" <sql411nospamcom@.discussions.microsoft.com> wrote in
message news:AC982762-1FDE-4D35-90BC-65143E226DC6@.microsoft.com...[vbcol=seagreen]
> Thank you, Andrew...
> I am using perfmon\process\working set\sqlservr.exe at it shows basically
> the same thing as task mgr.
> I have did check memory/commited bytes and see that the amount committed
> is
> equal to what I would expect SQL + the OS and other things to be. How can
> I
> verify that SQL Server has 7GB locked in?
> "Andrew J. Kelly" wrote:
>