How to correctly use /PAE and AWE

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jerrick D.H (D.H_at_discussions.microsoft.com)
Date: 07/09/04 

Date: Fri, 9 Jul 2004 11:12:01 -0700

Setup:
OS: Windows 2000 Advance Server
SQL Server 2000 Enterprise Edition service pack 3a – 1 instance
Ram upgraded from 4GB to 11GB
/PAE switch added to Bootini
SQL Server configuration settings – default
CPU 4 x 1.4
Cluster Active passive

We upgraded the 2 servers in the cluster from 4GB to 11GB Ram each and would like to enable AWE .
1. Based on my reading I would also have to set Max Server Memory and Set Working Size configuration options how would I determine appropriate values for these options?
2. Are they other options that I need to be concerned with?
3. Other than starving the OS what else can be affected by this change?
4. Are there any other default settings that have to be changed?

SQL Server is the primary application running on the cluster. There are no applications compiled to use 3GB memory.

Relevant Pages

  • Re: A significant part of sql server process memory has been paged ou
    ... I spoke with the correct people at Microsoft about this at the PASS Summit a few weeks ago. ... No guarantees they will move the feature to Standard Edition, but they are now treating it as a stability issue rather than an scalability issue. ... We have just configured SQL Server 2005 64-bit two node active/passive ... Total Server Memory shows value 16MB at the moment. ...
    (microsoft.public.sqlserver.setup)
  • Re: Increasing Max Memory on second node of failover clusterring
    ... SQL Server Buffer Manager:Target Pages ... SQL Server Memory Manager:Target Server Memory ... On Windows Server 2003, this happens automatically whenever more than 4 ...
    (microsoft.public.sqlserver.clustering)
  • Re: (Target Server Memory)Perf. Monitor Counters
    ... What is the Total Server Memory counter value? ... I support the Professional Association for SQL Server ... > the SQL Server Memory Manager (Target Server Memory) value. ... > RECONFIGURE ...
    (microsoft.public.sqlserver.server)
  • Re: Killer scripts
    ... The 'min server memory' and 'max server memory' configuration settings can ... be used to restrict the amount of RAM available to SQL Server. ... > A script causing high CPU usage ... > A script causing high memory usage ...
    (microsoft.public.sqlserver.programming)
  • RE: Memory problem
    ... I guess that the SQL Server is configured to use Dynamic Memory ... SQL Server memory will continue to grow as long as there is no RAM pressure ... start to release memory for other applications use or to avoid swapping. ...
    (microsoft.public.sqlserver.msde)