Posted on 2007-08-07
Last Modified: 2013-11-05
I am running into problems where it appears that some process in SQL is eating a large chunk of memory, tying up my server.  I am running Windows 2003 R2 Standard (32-bit) and SQL 2005 Standard.  All with default settings (no PAE and AWE is not running on SQL).  My server has 4GB of RAM.

1)  Based on my OS and 32-bit version, I'm assuming I don't need to enable PAE.  Am I right?
2)  Does it make sense to enable AWE in SQL with this hardware config (4GB RAM)?
Question by:wbrooksjr
    LVL 11

    Accepted Solution

    1) Yes, you are right. PAE will only enable access to memory above 4 GB. But it will not give you more than 2 GB of RAM per process.

    2) It would make sense if you need more than 2 GB of RAM for SQL Server. AWE will enable 3 GB of RAM per process. We activated it because of some memory problems and it solved them. Remember that the system should get enough memory. If you have 3 GB only, AWE should not be enabled. In your configuration it should be save to enable AWE.

    Here are some more things to think about:
    LVL 12

    Expert Comment


    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now