2nd instance of an active\active cluster Fails to allocate min memory

• westrrrr

  SSC Enthusiast

  Points: 115

  More actions

  July 6, 2004 at 5:18 am

  #83298

  Has anyone experienced this strange type of problem before.

  I'm currently running 2 SQl Instance as an active/active cluster.

  Both servers are identical running windows 2000 Advance server.

  SQl Server Enterprise 2000 with settings exactly the same on both servers.

  with 8GB of memory, both servers are new builds, Windows sees all the memory, boot.ini as 3gb pae switches and SQl’s are awe configured. 

  Instance 1 running as default virtual server on node 1

  Min server memory 5092

  Max Server memory 7406

  Uses all available memory.

  Instance 2 running as named instance of virtual server on node 2

  Min server memory 5092

  Max Server memory 7406

  Fails to allocate min memory error in log

  Runs using only 3.73 GB as max

  But I'm getting excessive page because more memory is needed.

   

  Ray

  I should add current active usage is node 1 uses 7.43 GB and node 2 uses 3.73GB which is over 11GB 

   

   

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  July 6, 2004 at 5:28 am

  #513445

  Posted reply against below link:  (Same topic)

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=124847

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net

• Johan Bijnens

  SSC Guru

  Points: 135361

  More actions

  July 7, 2004 at 12:46 am

  #513575

  - 1) the sum of both "Min server memory" ( 5092 *2 ) > (8Gb - 1 Gb)

          (the -1Gb is the space for the OS to run and manage the box with 

            AWE)

  - 2) If you second instance 'only' uses 3 Gb, reduce it's minimum server memory to that size.

  - 3) If I'm correct, with AWE enabled, SQLServer always grabs Max server memory at startup !!!

  Check out http://www.sqlservercentral.com/columnists/jsack/aweadventures.asp

   and http://www.sql-server-performance.com/awe_memory.asp

    

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution 😀

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me