Error: Server computer is running low on memory

• Justin-14543

  SSCrazy

  Points: 2017

  More actions

  March 4, 2003 at 1:49 pm

  #151799

  When I try to process my cube, I am getting this error message:

  Server computer is running low on memory. Close other app and try again.

  I don't have any other app running. Also the server has 4GB memory and over 5.5GB page file on W2K server. Ofcourse this dimension has about 24 million rows. When it crosses 7 million rows read, it errors out. What are my options other than adding hardware.

  Give me a fish, you feed me for a day! Teach me to fish, you feed me for a life time.

• Antares686

  SSC Guru

  Points: 125444

  More actions

  March 5, 2003 at 5:17 am

  #450306

  Do you have AWE enabled and he /3GB switch in your boot.ini file for the OS. If not then SQL Cannot see past the first 2 GB of RAM.

  See "Managing AWE Memory" in SQL BOL

  Note: I assume SQL 2000 in this post. If 7 it is caled PAE I believe, search SQL BOL for PAE for more info.