Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2002
    Posts
    1,245

    Unanswered: 2.6GB RAM: /PAE or not to /PAE?

    I have a couple of servers configured with 2.6GB RAM. My NT Admin came in the other day and told me he had been looking at performance on an unrelated server and discovered that he needed the /PAE switch enabled in order to see the full 16GB available on that server.

    He then convinced me that we needed to set the /PAE switch on all our SQL servers with more than 2GB of memory.

    I checked sp_configure after setting /PAE and both servers show that 'max server memory (MB)' is 2559 (which is what I would have expected).

    Do I need to do something more? Is the /PAE switch required in my case?

    Regards,

    hmscott

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Personally, I would not set that switch for servers running less than say 5GB of memory. There are two switches that can be added to boot parameters (ok, I don't know exactly where...)

    /3GB allows applications to use up to 3GB of memory (standard limit is 2GB on a 32 bit system)
    /PAE allows applications to use a heck of a lot more memory.

    In both cases, you have to remember that the operating system (and any other applications) want to use some of that precious memory, too. If SQL Server is eating all 2559MB of memory, you could end up with the paging file getting hit an awful lot more than you would like. In your case, I would definately avoid both switches, and let the OS use the other 500MB of memory.

  3. #3
    Join Date
    Dec 2002
    Posts
    1,245
    Thanks for the tip. I will consult with the NT Admin and see what he thinks. I'm inclined to push for your recommendations.

    Regards,

    hmscott

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •