As per SQL Server Books Online topic "Managing AWE Memory"
Use System Monitor (Performance Monitor in Microsoft Windows NT® 4.0) to retrieve information on SQL Server memory usage and available memory.
Task Manager does not provide accurate memory usage
information for AWE.
Therefore, the memory quoted for sqlservr.exe is NOT correct.
To obtain the correct amount of SQL Server memory usage, you can use the Total Server Memory (KB) performance counter,
activated through System Monitor, or select the memory usage from sysperfinfo.
For more information, see Monitoring Memory Usage.
Also, make sure that the MSSQLServer service account has been assigned the "Lock Pages in Memory" privilege on both nodes.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure?
For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities.
The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|