SQL Server 2000 Memory

• Kenny Yen

  Mr or Mrs. 500

  Points: 559

  More actions

  June 29, 2005 at 8:48 am

  #152450

  I have a cluster SQL Server 2000 whcih has 8GB ram. I am confused by swich /3GB & /PAE. Which the following one should I use in boot.ini ?

  Thanks a lot

   

  1. /3GB

  2. /PAE

  3. /3GB /PAE

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  June 29, 2005 at 3:16 pm

  #569601

  Unless the operating system will be needing a lot of memory (it normally does not) you should go with option 3. And you will of course also need to activate AWE in SQL Server.

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

• RML51

  SSCarpal Tunnel

  Points: 4410

  More actions

  June 30, 2005 at 6:56 am

  #569752

  If your hardware has "hot-add" memory, I don't think you need either switch - just AWE.