MemToLeave area! How to monitor?

Please, take a look at "Inside SQL Server 2000's Memory Management Facilitie
s" by Ken Henderson:

http://msdn.microsoft.com/library/d...ev_01262004.asp

"... None of the tools you typically use to inspect application memory use (
Task Manager, Perfmon/Sysmon, etc.) show the amount of AWE memory used by in
dividual processes. There's no indication of the amount of AWE memory used b
y each process, nor is this
memory included in the working set size reported for a given process ..."

Thanks,
-Ivan

-----Original Message-----
From: james
Posted At: Tuesday, February 28, 2006 6:52 AM
Posted To: microsoft.public.sqlserver.server
Conversation: MemToLeave area! How to monitor?
Subject: MemToLeave area! How to monitor?



Gurus,
Occasionally I get the error of "WARNING:  Failed to reserve contiguous memo
ry of Size= 65536."
What is the unit for this size, is it bytes or KB?  Additionally,

I have set up 511 MB for MemToLeave area by adding -g384 for Sql2k SP3a on A
WE enabled system. I have total of 16 GB of RAM, of which 14 GB is set up ma
ximum for Sql server.
If I look at Perfmon counter of Process->Private bytes for sql server proces
s it gives me 224 MB.
If I look at sqlserver.exe process on task manager it gives me 215MB.
If I look at DBCC memorystatus, OS in use, it gives me 12 MB.

I would like to know, How can I calculate exactly how much memory is being a
ssigned and how much in use from MemToLeave area by looking at above mention
ed counters or any other perfmon or dbcc counters?

I really appreciate any input on this matter.

Thanks Ivan. I had already checked that article and also few other google
search but didn't get the answer.
<ivanpe@online.microsoft.com> wrote in message
news:OenNh9IPGHA.3840@TK2MSFTNGP14.phx.gbl...
> Please, take a look at "Inside SQL Server 2000's Memory Management
> Facilities" by Ken Henderson:
>
> http://msdn.microsoft.com/library/d...ev_01262004.asp
>
> "... None of the tools you typically use to inspect application memory use
> (Task Manager, Perfmon/Sysmon, etc.) show the amount of AWE memory used by
> individual processes. There's no indication of the amount of AWE memory
> used by each process, nor is this memory included in the working set size
> reported for a given process ..."
>
> Thanks,
> -Ivan
>
> -----Original Message-----
> From: james
> Posted At: Tuesday, February 28, 2006 6:52 AM
> Posted To: microsoft.public.sqlserver.server
> Conversation: MemToLeave area! How to monitor?
> Subject: MemToLeave area! How to monitor?
>
>
>
> Gurus,
> Occasionally I get the error of "WARNING:  Failed to reserve contiguous
> memory of Size= 65536."
> What is the unit for this size, is it bytes or KB?  Additionally,
>
> I have set up 511 MB for MemToLeave area by adding -g384 for Sql2k SP3a on
> AWE enabled system. I have total of 16 GB of RAM, of which 14 GB is set up
> maximum for Sql server.
> If I look at Perfmon counter of Process->Private bytes for sql server
> process it gives me 224 MB.
> If I look at sqlserver.exe process on task manager it gives me 215MB.
> If I look at DBCC memorystatus, OS in use, it gives me 12 MB.
>
> I would like to know, How can I calculate exactly how much memory is being
> assigned and how much in use from MemToLeave area by looking at above
> mentioned counters or any other perfmon or dbcc counters?
>
> I really appreciate any input on this matter.