AWE memory usage in Task Manager

• shahgols

  SSCrazy Eights

  Points: 9874

  More actions

  December 6, 2007 at 1:57 pm

  #119348

  Hi everyone,

  I'm running SQL 2005 Enterprise and Windows 2003 Enterprise on several of my servers. I've set them all up to use AWE using the instructions at:

  http://msdn2.microsoft.com/en-us/library/ms190673.aspx

  All SQL Server logs state that AWE is enabled, but when I look at the memory usage for sqlserver in Task Manager, they are using somewhere between 80MB to 150MB of RAM. When I disable AWE, Task Manager shows 1.6GB of RAM being used. Have you seen this before? Thanks in advance for your help.

• Carl Federl

  One Orange Chip

  Points: 25384

  More actions

  December 6, 2007 at 2:10 pm

  #757864

  Task Manager does not provide accurate memory usage information for AWE. System Monitor should be used instead.

  http://msdn2.microsoft.com/en-us/library/aa213764(sql.80).aspx

  Process explorer can show more information as is available at http://www.microsoft.com/technet/sysinternals/default.mspx

  SQL = Scarcely Qualifies as a Language

• shahgols

  SSCrazy Eights

  Points: 9874

  More actions

  December 6, 2007 at 2:20 pm

  #757865

  Thank you Carl!