<div>
<a href="http://sqlnerd.blogspot.com/2006/07/memory-use-in-sql-server.html" rel="ugc">http://sqlnerd.blogspot.com/2006/07/memory-use-in-sql-server.html</a><br />

</div>


http://sqlnerd.blogspot.com/2006/07/memory-use-in-sql-server.html [http://sqlnerd.blogspot.com/2006/07/memory-use-in-sql-server.html]


<div>
You can try with this first<br />
<a href="http://support.microsoft.com/kb/911716" rel="ugc nofollow">http://support.microsoft.com/kb/911716</a><br />
<br />
To monitor the app memory usage you can use Ants profiler - is best one I know
</div>


You can try with this first
http://support.microsoft.com/kb/911716 [http://support.microsoft.com/kb/911716]

To monitor the app memory usage you can use Ants profiler - is best one I know

<div>
Hi Tygrus2,<br />
<br />
How about AWE* counters under SQL Server:Buffer Manager? Just wondering, should I use this counters instead? Any idea?<br />
<br />
Thanks,<br />

</div>


Hi Tygrus2,

How about AWE* counters under SQL Server:Buffer Manager? Just wondering, should I use this counters instead? Any idea?

Thanks,


<div>
<div class="content wysiwyg-content">
Dear All,<br />
<br />
AWE is enabled on SERVER_ABC with 8GB RAM. Max memory is set to 5GB. <br />
<br />
How do I know that the 5GB RAM is enough? Am I allocating too much memory for SQL? <br />
<br />
Should I use perfmon to monitor? If yes, then what are the counters in the perfmon that I should use to monitor?<br />
<br />
I noticed that there are AWE* counters under SQL Server:Buffer Manager, however I don't know how to read these counters. Are these counters reliable?<br />
<br />
Any feedback/suggestions.<br />
<br />
Cheers,
</div>
</div>


Dear All,

AWE is enabled on SERVER_ABC with 8GB RAM. Max memory is set to 5GB. 

How do I know that the 5GB RAM is enough? Am I allocating too much memory for SQL? 

Should I use perfmon to monitor? If yes, then what are the counters in the perfmon that I should use to monitor?

I noticed that there are AWE* counters under SQL Server:Buffer Manager, however I don't know how to read these counters. Are these counters reliable?

Any feedback/suggestions.

Cheers,

How to monitor the memory consumed by SQL server (with AWE enabled)

Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).

Windows Server 2003

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.