Friday, March 30, 2012

How to verify Server sees 8GB of Memory

We are running SQL Server 2000 on Windows 2000 Advanced
Server and have just upgraded our memory from 4GB to 8GB.
We have added the /3gb and /pae switches to the boot.ini,
but every memory indicator still only shows 4GB (right
clicking my computer, memory settings in enterprise
manager and memory in performance monitoring). Is this
correct or is the server not seeing the memory? Thanks.My guess would be you really have just plain WIn2000 Server and not
advanced.
--
Andrew J. Kelly SQL MVP
"Chris" <anonymous@.discussions.microsoft.com> wrote in message
news:207801c49a7e$71195960$a501280a@.phx.gbl...
> We are running SQL Server 2000 on Windows 2000 Advanced
> Server and have just upgraded our memory from 4GB to 8GB.
> We have added the /3gb and /pae switches to the boot.ini,
> but every memory indicator still only shows 4GB (right
> clicking my computer, memory settings in enterprise
> manager and memory in performance monitoring). Is this
> correct or is the server not seeing the memory? Thanks.|||Chris,
you still need to run the following in QA:
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 6144 --(6144 the number of memory for SQL
Server in MB)
RECONFIGURE
GO
"Chris" <anonymous@.discussions.microsoft.com> wrote in message
news:207801c49a7e$71195960$a501280a@.phx.gbl...
> We are running SQL Server 2000 on Windows 2000 Advanced
> Server and have just upgraded our memory from 4GB to 8GB.
> We have added the /3gb and /pae switches to the boot.ini,
> but every memory indicator still only shows 4GB (right
> clicking my computer, memory settings in enterprise
> manager and memory in performance monitoring). Is this
> correct or is the server not seeing the memory? Thanks.

No comments:

Post a Comment