3GB switch in boot ini

I have a server which has 4gig of memory. I have
modified the boot.ini file to include the /3GB switch. I
have looked at the process work set for SQLServer and it
still appears to be using only 2gig's of memory. This
server does have WIN2K Advance server and is also SQL
Server 200 Enterprise.
How can I find out if SQL Server is using the 3 gig I
have available?
thanksPerformance Monitor Counter:
SQL Server: Memory Manager:Total Server Memory
Kevin Connell, MCDBA
----
The views expressed here are my own
and not of my employer.
----
"Kevin" <anonymous@.discussions.microsoft.com> wrote in message
news:00b501c39fc8$debf2410$a101280a@.phx.gbl...
> I have a server which has 4gig of memory. I have
> modified the boot.ini file to include the /3GB switch. I
> have looked at the process work set for SQLServer and it
> still appears to be using only 2gig's of memory. This
> server does have WIN2K Advance server and is also SQL
> Server 200 Enterprise.
> How can I find out if SQL Server is using the 3 gig I
> have available?
> thanks|||"Kevin" <anonymous@.discussions.microsoft.com> wrote in message
news:00b501c39fc8$debf2410$a101280a@.phx.gbl...
> I have a server which has 4gig of memory. I have
> modified the boot.ini file to include the /3GB switch. I
> have looked at the process work set for SQLServer and it
> still appears to be using only 2gig's of memory. This
> server does have WIN2K Advance server and is also SQL
> Server 200 Enterprise.
> How can I find out if SQL Server is using the 3 gig I
> have available?
Performance monitor (Perfmon.exe) would be one way...
Steve|||That is what I used and it still only shows 1700544. The
Process:Work Set counter for SQLServr shows 1.7gig also.
I have SQL set to dynamic allocation. Seems the the
switch made no difference.
thanks
>--Original Message--
>Performance Monitor Counter:
>SQL Server: Memory Manager:Total Server Memory
>
>--
>Kevin Connell, MCDBA
>----
>The views expressed here are my own
>and not of my employer.
>----
>"Kevin" <anonymous@.discussions.microsoft.com> wrote in
message
>news:00b501c39fc8$debf2410$a101280a@.phx.gbl...
>> I have a server which has 4gig of memory. I have
>> modified the boot.ini file to include the /3GB
switch. I
>> have looked at the process work set for SQLServer and
it
>> still appears to be using only 2gig's of memory. This
>> server does have WIN2K Advance server and is also SQL
>> Server 200 Enterprise.
>> How can I find out if SQL Server is using the 3 gig I
>> have available?
>> thanks
>
>.
>|||Something in the back of mind is reminding me that you actually need more
than 4GB of RAM to take advantage of >2GB memory, and that that docs are
either wrong or misleading, but I may be thinking about PAE/AWE. Try to
enable /PAE and AWE and see where that leads you.
--
Kevin Connell, MCDBA
----
The views expressed here are my own
and not of my employer.
----
<anonymous@.discussions.microsoft.com> wrote in message
news:00c601c39fe7$b63eb310$a601280a@.phx.gbl...
> That is what I used and it still only shows 1700544. The
> Process:Work Set counter for SQLServr shows 1.7gig also.
> I have SQL set to dynamic allocation. Seems the the
> switch made no difference.
> thanks
> >--Original Message--
> >Performance Monitor Counter:
> >
> >SQL Server: Memory Manager:Total Server Memory
> >
> >
> >--
> >Kevin Connell, MCDBA
> >----
> >The views expressed here are my own
> >and not of my employer.
> >----
> >"Kevin" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:00b501c39fc8$debf2410$a101280a@.phx.gbl...
> >> I have a server which has 4gig of memory. I have
> >> modified the boot.ini file to include the /3GB
> switch. I
> >> have looked at the process work set for SQLServer and
> it
> >> still appears to be using only 2gig's of memory. This
> >> server does have WIN2K Advance server and is also SQL
> >> Server 200 Enterprise.
> >>
> >> How can I find out if SQL Server is using the 3 gig I
> >> have available?
> >>
> >> thanks
> >
> >
> >.
> >