AWE Problems on SQL 2000 Cluster

• Ned

  Ten Centuries

  Points: 1214

  More actions

  April 11, 2005 at 2:11 pm

  #110044

  We just topped up the memory in our SQL Cluster to 8 GB. I fired up perfmon to make sure that the instances were taking advantage of the extra RAM and found that the Memory Manager Total Server Memory is way lower than the Target Server Memory. According to the Total Server Memory counter each instances is taking up an average of 120 MB! These are boxes are dedicated to SQL server. I can't see why the instances can't grab more memory than they are. Any input would be much appreciated.

  I have the following setup:

  SQL 2000 Enterprise

  Windows 2003 Enterprise

  2 Node 4 Instance Active/Passive Cluster

  8 GB RAM on each node

  /PAE and /3GB in boot.ini and OS recognizes full 8 GB

  AWE enabled on each instance

  Each Instance configured with max server memory = 1536 MB

   

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  April 11, 2005 at 3:53 pm

  #551978

  See my reply in the other thread, and please do not cross post.

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/