We have enabled AWE on our SQL 2000/Win 2003 Ent servers and are now having
problems seeing true memory utilization by SQL Server. For example, Task
Manager shows SQL only using 174,712 k when it has been configured to 13gb.
Not to mention perfmon memory object is not reporting accurately either.
With that said, is this a known issue and what is the work around? I want
to be able to guage if we need more than 16gb on this box.
Thanks!
Michael
Task manager cannot count higher than 2GB of memory. The performance
monitor counters will give accurate memory usage. Another quick and dirty
way is to look at Page File usage. AWE usage shows up as page file
committment.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"BATMAN" <BATMAN@.discussions.microsoft.com> wrote in message
news:48B6C39B-8DB3-4B20-B487-935ADF37D952@.microsoft.com...
> We have enabled AWE on our SQL 2000/Win 2003 Ent servers and are now
> having
> problems seeing true memory utilization by SQL Server. For example, Task
> Manager shows SQL only using 174,712 k when it has been configured to
> 13gb.
> Not to mention perfmon memory object is not reporting accurately either.
> With that said, is this a known issue and what is the work around? I want
> to be able to guage if we need more than 16gb on this box.
> Thanks!
> Michael
>
No comments:
Post a Comment