How to use 4GB of RAM in OLAP?

• htt

  SSCertifiable

  Points: 5242

  More actions

  January 5, 2006 at 4:39 pm

  #152689

  I am trying to install my first OLAP server.  The server is an HP ML570 4 CPUs and 4GB of RAM.  The O/S is Windows 2003 Enterprise edtion.  SQL 2000 Ent is installed also.  OLAP is needed for OutlookSoft, a management s/w.  Per installation instructions I set the Memory Conservation Threshold = the amount of RAM on the server = 4GB.  However the max I can set is 3072.  What do I need to make it takes 4096?  Thanks.

   

• Paul Mu

  SSCertifiable

  Points: 5547

  More actions

  January 5, 2006 at 6:13 pm

  #613081

  You will be limited by the flavor of Windows OS. Have a read of this article for more info:

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