(Target Server Memory)Perf. Monitor Counters

Yes, we have AWE set to 1 and max server memory set to
5120. Yes, this is a SQL Server 2000 Enterprise Edition
with Windows 2000 Advanced Server. SQL Server is
clustered also. After the 2GB of RAM (6GB + 2GB) was
added to the server the script listed below was applied to
the server.
We have three other servers that have the same
configuration and SQL Server Memory Manager (Target Server
Memory) is set correctly at 5.12GB. But when you run
Performance Monitor and display SQL Server Memory Manager
(Target Server Memory) it is set to 2.7GB
I replied the script listed below but it did not change
the SQL Server Memory Manager (Target Server Memory) value.
Please help me with this problem.
Thanks,
Mike
sp_configure "show advanced options", 1
RECONFIGURE
GO
sp_configure "awe enabled", 1
RECONFIGURE
GO
sp_configure "max server memory", 5120
RECONFIGURE
GO
sp_configure "min server memory", 0
RECONFIGURE
GO
Do you have AWE enabled in SQL?
Are you running Enterprise Edition SQL?
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Mike" <anonymous@.discussions.microsoft.com> wrote in
message
news:8ea801c432f6$f47ddf50$a501280a@.phx.gbl...
> Why does'nt my Target Server Memory value (2.7 GB) within
> Memory Manager in the Performance Monitor Counters match
> the values in SQL Server Memory Maximum Value (5.2 GB)
> My Target Server Memory displays a value of 2.7 GB and
the
> SQL Memory Maximum displays 5.2 GB.
> The boot.ini is set with the following parameters:
> [boot loader]
> timeout=10
> default=multi(0)disk(0)rdisk(0)partition
(1)\WINNT
> [operating systems]
> multi(0)disk(0)rdisk(0)partition(1)\WINN
T="Microsoft
> Windows 2000 Advanced Server" /fastdetect /3gb /PAE
> The server initially had 6GB of RAM and 2GB were added to
> the server. SQL Server displays 5.2 GB is the maximum
alot
> memory and Dynamically configure SQL Server memory.
> How can I fix the memory problem.
> Thanks,
> Mike
>
.What is the Total Server Memory counter value?
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:94e101c43372$1237ed80$a001280a@.phx.gbl...
> Yes, we have AWE set to 1 and max server memory set to
> 5120. Yes, this is a SQL Server 2000 Enterprise Edition
> with Windows 2000 Advanced Server. SQL Server is
> clustered also. After the 2GB of RAM (6GB + 2GB) was
> added to the server the script listed below was applied to
> the server.
> We have three other servers that have the same
> configuration and SQL Server Memory Manager (Target Server
> Memory) is set correctly at 5.12GB. But when you run
> Performance Monitor and display SQL Server Memory Manager
> (Target Server Memory) it is set to 2.7GB
> I replied the script listed below but it did not change
> the SQL Server Memory Manager (Target Server Memory) value.
> Please help me with this problem.
> Thanks,
> Mike
>
> sp_configure "show advanced options", 1
> RECONFIGURE
> GO
> sp_configure "awe enabled", 1
> RECONFIGURE
> GO
> sp_configure "max server memory", 5120
> RECONFIGURE
> GO
> sp_configure "min server memory", 0
> RECONFIGURE
> GO
>
>
> Do you have AWE enabled in SQL?
> Are you running Enterprise Edition SQL?
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> "Mike" <anonymous@.discussions.microsoft.com> wrote in
> message
> news:8ea801c432f6$f47ddf50$a501280a@.phx.gbl...
> the
> alot
>
> .
>|||The Total Server Memory counter value?
8,125,736 KB of RAM
Thank You,
Mike

>--Original Message--
>What is the Total Server Memory counter value?
>--
>Geoff N. Hiten
>Microsoft SQL Server MVP
>Senior Database Administrator
>Careerbuilder.com
>I support the Professional Association for SQL Server
>www.sqlpass.org
>"Mike" <anonymous@.discussions.microsoft.com> wrote in
message
>news:94e101c43372$1237ed80$a001280a@.phx.gbl...
to[vbcol=seagreen]
Server[vbcol=seagreen]
Manager[vbcol=seagreen]
value.[vbcol=seagreen]
within[vbcol=seagreen]
match[vbcol=seagreen]
added to[vbcol=seagreen]
>
>.
>