Saturday, February 11, 2012

(Target Server Memory)Perf. Monitor Counters

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)\WINNT="Microso ft
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
Do you have AWE enabled in SQL?
Are you rinning 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)\WINNT="Microso ft
> 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
>

No comments:

Post a Comment