/3GB switch - need to set "max server memory"?

• Fred Williams-134192

  SSCrazy

  Points: 2482

  More actions

  May 2, 2005 at 12:38 am

  #87403

  Do I need to set "max server memory" to something > 2GB when using the /3GB (boot.ini) switch? Or will the default dynamic memory management recognize the switch and use more than the default 2GB application address space if needed?

  Server is 2 processor, with 4GB of physical memory, running Windows 2000 Advanced Server, and SQL 2000 Enterprise edition. Other than an occasional remote login, SQL Server and Agent are the only things running on the box.

  If I need to set "max server memory" to take advantage of the /3GB switch, what would be a good value? 2.7GB? Any reason to set "min server memory" or "working set size"?

  Thanks...

• noeld

  SSC Guru

  Points: 96590

  More actions

  May 2, 2005 at 11:24 am

  #556353

  In your case

  -max server memory is not needed.  (use dynamic)

  -min server memory neither (use dynamic)

  and because I am recomending dynamic allocation "working set size" does not need to change !

   

  Cheers,

   

  
  * Noel